OneStream Community

mpavan · 05-09-2023

Hello Experts, We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account)This has to be done for range of accounts. I am not sure if there a any functions to refer data value...

mpavan · 04-27-2023

Hello Experts, I have a requirement of calculating Cash_ADJ based a sum value of 2 different buffers. If the sum value is Positive I have to post a cash_adj with value from bufSrc2. Is it possible to filter Buffer 1 and write corresponding buffer 2 v...

mpavan · 04-18-2023

Hello All, I am new to OneStream trying to write a Value Override business rule for some investment accounts, The rule works without account filter. How ever I want to restrict this to Accounts with Text2 tag as "CADOverride". Somehow the value becom...

mpavan · 05-15-2023

Hello Lee, Sorry for the delay.I had started to work on it but unfortunately account hierarchy is little messy and we do not have a defined range. Due to missing range Derivate rules are becoming complex. We went with the Event Handler rule that runs...

mpavan · 04-28-2023

Thanks' for the suggestion. I have tried but unable to make it work using member formula. Still a lot of learning to do. In the meanwhile I had used api.calculate with in the loop and it had worked as expected, If ((Not api.Entity.HasChildren()) And ...

mpavan · 04-20-2023

Thanks for the explanation!I understand the simple way of looping through a member list.https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Using-the-EVAL-function-to-loop-through-a-tagged-set-of-Balance/ta-p/6006 Is the above post simil...

mpavan · 04-20-2023

Hello ChrisLoran, I was wondering what the option is for and thanks for the code. Although we have only one parent currency this gives us flexibility in future and will incorporate this code.The reason I am trying to limit the account for Override co...

OneStream Community

User Statistics

User Activity

Derive account based on Data Value in Transformation Rules.

Filter Result DataBuffer based on value in secondary Source Buffer

Unable to Calculate Currency Override only for Accounts with Text Filter.

Re: Derive account based on Data Value in Transformation Rules.

Re: Filter Result DataBuffer based on value in secondary Source Buffer

Re: Unable to Calculate Currency Override only for Accounts with Text Filter.

Re: Unable to Calculate Currency Override only for Accounts with Text Filter.