OneStream Community

MStucchi · 02-01-2023

Hi all, We have a requirement to run IC Matching report including journal that may have been posted as parent adjustment. In this way we are also excluding form IC MAtching deconsolidated entities and considering the amount based on the consolidation...

MStucchi · 01-12-2023

We are trying to load txt file to custom table using LoadCustomTableUsingDelimitedFile but when it runs we receive a "Data load file is invalid or missing" error. The file is manually selected from a folder. The file is correct, the number of fields ...

MStucchi · 12-28-2022

Hi all, I'm receiving the error in the subject when executing a MemberList. This is the ML code, it should retrieve base member of "TF" in the flows dimension with SwitchType attribute set to True. Dim objMemberListHeader As New MemberListHeader(args...

Retrieve member name · 06-30-2022

Hi all, I'm bit new in developing rules in one stream and I have a simple question. I'm trying to retrieve the accountId member name from a member formula on the account itself. I'm using the below code but it seems api.Pov.Account.Name is not workin...

MStucchi · 01-16-2023

Thanks, moving to the file to the share path worked.As the file is received by email, we are looking on how to select it from local folder and move it to the share path before is being loaded.Thanks and regardsMassimo

MStucchi · 12-28-2022

Thanks Chris.....I totally missed I was adding the item to the same list i am looping....RegardsMassimo

Re: Retrieve member name · 07-01-2022

I thought it was related to the fact that Account is not part of the POV.Thanks for your expplanation,perfectly clear and detailed.I'm wondering anyway why when compiling a member formula with api.pov.account does not rise any warning, it probably ch...

Re: Retrieve member name · 06-30-2022

Thanks, in the end i need to retrieve the accountID, but to do that I need the account name.I'm trying to retrieve account name using api.pov.account.name but it returns blank.If I write the account name like this Dim AcctId As Integer = api.Members....

MStucchi · 06-30-2022

Hi, try to check that the variable which stores the value in your business rule is declared as decimal.

OneStream Community

User Statistics

User Activity

IC Matching report before elimination

Loading txt file to custom table

"Collection was modified; enumeration operation may not execute" error when executing a member list

Retrieve member name

Re: Loading txt file to custom table

Re: "Collection was modified; enumeration operation may not execute" error when executing

Re: Retrieve member name

Re: Retrieve member name

Re: Error in business rule