OneStream EmployeeAll dynamic calcs are taking place after the aggregation so the answer is no, but a node can be a dynamic calc as well, this might help to get the expected result.
You need to loop the base members and sum them up in a variable before returning the variable.
Sorry, I‘m travelling the next days and therefore can’t create a sample for you.
Cheers
Thank you for your feedback.
The flow member ‘AggDetail’ is already set to dynamic calc and working fine for all UD1 base members which are created under the 'Financial Detail' cube in dimension library. However, the same 'AggDetail' member is not pulling any results for Parents/SubParents UD1s members that are created under the ‘Financial’ cube in Dimension library.
Here is our situation:
>> All base UD1(Function/Cost Center) members are created under the ‘Financial Detail’ cube in Dimension Library
>> All Parents/Sub Parents UD1 (Function/Cost Center) members are created under the “Financial’ cube in Dimension Library
>> We have dynamic calc member in Flow Dimension call ‘AggDetail’ which aggregates the data on the fly for UD1 by entity. See below snapshots.
Dynamic Calc Flow Member “AggDetail” with Member Formula:
Base UD1 members are created under the ‘Financial Detail’ cube in Dimension Library:
Parents and Sub Parents UD1 members are created under the ‘Financial’ cube in Dimension Library:
AggFlow’ Dynamic Calc member pulling the results on-the-fly for all base UD1 members (CC_ & G_) but not showing anything on Parent/SubParent UD1 (T_).
Thank you
