OneStream Community

SimpleLove

Dear OneStream Experts: Thank you so much for the great help in the past. I am converting one Hyperion Planning application to OneStream application and would like to know how to use if statement to check calculation flag. For example: I have 3 dimen...

SimpleLove

Hello OneStream Expert: We are going to to convert one Hyperion Planning application to OneStream Application. In Hyperion application we have SmartList type of Datatype, for example we have an Account Member call Display_Flag 1, Yes 2. No In web for...

SimpleLove

Hello every expert: I am not able to reference a different scenario member in custom calculation business rule. I tried the following api.Data.Calculate("S#Forecast=S#Actual","A#10100" ...........) in the finance business rule I created. When I run t...

SimpleLove · 05-21-2024

Hello OneStream Experts: I created an account called MyAcct to store calculation. I run the business rule in Data Management step and put Net Income to MyAcct. api.Data.Calculate("A#MyAcct = A#NETINC") After I run the business rule, the Calc Status i...

SimpleLove · 05-21-2024

Hello OneStream experts: I created and account=MyAccount and put member formula. api.Data.Calculate("A#MyAccount = A#NETINC") I set AccountType=Dynamic Calc Formula Type=Formula Pass 1 I am able to compile the syntax and run the calculation successfu...

SimpleLove

@Henning: Thank you so much for providing this great solution.

SimpleLove

@JackLacava Your advice is really helpful. Thanks a lot.

SimpleLove

Hello Albert: Thank you for the help. I found that my Actual and Forecast scenario need to be same Scenario type. If they are not the same I cannot do the following calculation in the business rule api.Data.Calculate("S#Forecast=S#Actual") I did set ...

SimpleLove · 05-22-2024

@sameburn: Thank you so much. I did use isdurabledata boolean in my business rule. I can see MyAcct numbers, calculated at base Entity, are not cleared when I run consolidation. However the Numbers in MyAcct account do not aggregate to my parent enti...

SimpleLove · 05-21-2024

@MikeG Thank you so much for the help. It works now. I have tried to set Account Type = Revenue, but I select formula type= Pass 1 and did not get data. I follow your suggestion and set it to Pass 6 and the calculation did work. It seems the formula ...

OneStream Community

User Statistics

User Activity

How to use if statement to check calculation flag

Does OneStream have smartlist type of data type?

How to reference a different scenario member in custom calculation business rule

Calculated Data lost after I run consolidation

Store Calculation not working

Re: Does OneStream have smartlist type of data type?

Re: How to reference a different scenario member in custom calculation business rule

Re: How to reference a different scenario member in custom calculation business rule

Re: Calculated Data lost after I run consolidation

Re: Store Calculation not working