How to use and optimize perfomance when using dynamic member in calculation
Hello everyone,
I have trouble with dynamic members in my calculation rule.
My member "PROFIT" is a parent and dynamic member under the Account hierarchy.
When writing the business rule, I used this member to calculate the % of each company:
SET UPDATECALC OFF; | |
---|---|
SET AGGMISSG ON; | |
SET EMPTYMEMBERSETS ON; |
FIX(@RELATIVE("Total Company",0)
"% of Profit" = PROFIT / PROFIT→"Total Company";
"Ori" = PROFIT;
ENDFIX
However, my rule did not show any result.
How should I fix this issue?
I realized that when I use dynamic members in calculation, my rule runs slowly.
Thanks and have a nice day!
Note: I am using PBCS, which does not have Groovy.
Tagged:
0