You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to use and optimize perfomance when using dynamic member in calculation

in Planning 22 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!