Hello all I have a case where a prior month total needs to roll into a base member of the current month total, then roll the logic forward into future periods. I'm running into an order of operations issue. I can't use two-pass because I'm calculating for members of non-account dim
I have two dims:
So I want to calculate for "PriorBase" something basically like this: PriorBase = @Prior(TotalInitiative->TotalSource);
The problem I'm running into is that Essbase is calculating period before PriorBase is calculated. I've worked around this issue by using LOOP (or running the calc 12 times!) but would hate to resort to that. Any suggestions?
thought about making TotalInitiative a dynamic calc and then wrapping the calc script in interdependancy brackets.
Stolen from the DBAG
https://docs.oracle.com/cd/E57185_01/ED ... devcs.html
If you are using an IF statement or an interdependent formula, enclose the formula in parentheses to associate it with the specified member.
For example, the following formula is associated with the Commission member in the database outline:
(IF(Sales < 100)
Commission = 0;