Dynamic Calc members are not aggregating when CALC DIM is used once
Hi all,
We have a sample hierarchy as below. Below are the member properties.
Net Sales: Store, Two Pass Calculation - Enabled
Gross Profit: Store, Two Pass Calculation - Not Enabled
Expense: Dynamic Calc, Tow Pass Calculation - Enabled (This member contains Member Formula which refers a member)
When we are using CALC DIM in the business rule along with other dimension as below,
CALCDIM("CostCenter","Account","Location");
the data calculated (2000 in the above image) is not aggregating to Net Sales. But when we are using CALC DIM command twice, it is aggregating correctly
FIX(Actual,Working)
CALCDIM("CostCenter","Account","Location");
Tagged:
0