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
DynamicCalc Account roll-up
Hi All,
Is there any option/setting for DynamicCalc account data rolled up to its parent (account type is expense)
T_Kress
OneStream Employee
OneStream EmployeeNo, I do not believe so. By nature, a dynamic account is calc-on-the-fly so the data is not stored; therefore, it cannot roll up to a parent account (which is also agg-on-fly). If you need a dynamic account to roll up, it needs to be a stored formula pass and not dynamic.
Further to T_Kress's response, the other alternative is to stick with your existing Dynamic Calc formula, but also add a Dynamic Calc to the parent, which would aggregate the children. With care, the aggregation Dynamic Calc formula should dynamically figure out what the children members are, while considering AccountType (if on the Account dim), AggregationWeight, InUse, so the formula doesn't need to change should someone alter the dim. You would need to rinse and repeat up any additional ancestors above the dynamic calc.
This strategy needs to be used by those who use Dynamic Calc's to compute a Cash Flow.
Hi rhankey, thanks for your prompt response. Yeah, I changed parent attribute to dynamic then children's data rolled up to its parent. unfortunately, this account under P&L hierarchy and some of parent members are referring in member formula.
If this dynamically computed account rolls into let's say NetIncome, then you have a problem, as NetIncome usually needs to be copied to the Balance Sheet as a stored calculation. Stored calculations do not include dynamically computed data without a fair bit of clumsy coding.
In another comment, you mentioned the formula includes division, which seems odd (to me as a non-trained accountant) for something that would roll into NetIncome. Formulas requiring division are commonly KPI's that reside outside the trial balance, where dynamic calcs make most sense. if this formula does require division and needs to be included in NetIncome, then you either compute it as a stored calc that is correct at base levels only, or else you are going to find this dynamic calc will lead to a cascade of additional dynamic calcs which will be very difficult to pull off if they reside within the trial balance.
Hi T_Kress, thanks for prompt response, actually I wrote member formula and not getting correct output. When I change account type and calculation as Dynamic then retrieving correct output. below is the formula
Account_OP = (Acct1+ Acct2)/ (Act1+Act2+Act3+act4) * Acct5, I observed that division not working. I seen diff between manual division and system division but whereas using Dynamic property then the system calculated correct value.
Is there any syntax for getting correct result of division.
Formulas with division almost always have to be computed as dynamic calcs, so they occur after any dimension aggregation. Performing division as a stored calc will be correct with base level data, but will usually not provide the desired results as you aggregate up the hierarchy.
Thanks, rhankey :)
