The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

aricgresko's avatar
aricgresko
Contributor III
2 years ago
Solved

Issue when referencing a DynamicCalc Account in a DynamicCalc UD8 member

I have UD8 DynamicCalc members that calculate various Growth %s.  These work as expected when the Account dimension member referenced in the formula has a normal Account Type (e.g., Revenue or Expens...
XFBR
  • PKiernan's avatar
    PKiernan
    2 years ago

    Can you put the UD8 member in the Dynamic Calc Account?

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

You mean you put a formula on a UD8 member, and it doesn't get executed when looking at an intersection of that member and an Account marked as DynamicCalc?

If so, that's the expected behaviour. Basically, OneStream will look for dynamic formulas to execute on a cell by following the "usual" calculation order, i.e. Account first, then Flow, then UD1, then UD2 etc etc. As soon as it finds a formula in one of the dimensions, it executes it, returns the value to the interface, and stops.

That means that, if you mark your Account as dynamic, OneStream will execute the Account formula and stop, without ever looking into other members.

  • aricgresko's avatar
    aricgresko
    Contributor III
    2 years ago

    Thanks for the info Jack; that totally makes sense with the order of operations.