Forum Discussion

SimpleLove's avatar
SimpleLove
New Contributor III
7 months ago

Calculated Data lost after I run consolidation

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#NE...
Finance
  • sameburn's avatar
    sameburn
    7 months ago

    Hi

    You need to set the isdurabledata boolean on the api e.g api.Data.Calculate("A#MyAcct = A#NETINC", True)

    Otherwise your data is not durable and will get cleared each time you consolidate

    Hope this helps

sameburn's avatar
sameburn
Contributor II

Hi

You need to set the isdurabledata boolean on the api e.g api.Data.Calculate("A#MyAcct = A#NETINC", True)

Otherwise your data is not durable and will get cleared each time you consolidate

Hope this helps

SimpleLove's avatar
SimpleLove
New Contributor III
7 months ago

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 entities after I run the consolidation. In the mean time, the numbers in my NETINC account do aggregate from base entities to parent entities. Thank you again for your help!

If(Not api.Entity.HasChildren() ) Then

api.Data.Calculate("A#MyAcct = A#NETINC"