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

calculate children members sum on parent member level for sparse Dimension on EPM Essbase Rule

in EPM Platform and Freeform

Hi,

I will try to describe the issue in the below lines

I have three sparse dimensions "Employee", "Job", "Position"

Let's say the three dimension have three parent members "Current_Employees","Current_Jobs", "Current_Positions" that have storage type as "Store and Dynamic Calc"

The three members shows the totals perfectly on Forms and Smartview without diving through their children members. However, In Essbase rule while using FIX("Existing_Employees","Existing_Positions","Existing_Jobs") , it does no actions. I must do it like below to make it works
FIX(@Relative ("Existing_Employees", 0),@Relative ("Existing_Jobs", 0),@Relative ("Existing_Positions", 0)).

The issue is that I need the total for specific Account before sending that total on all children of "Existing_Employees, Existing_Positions,Existing_Jobs" from Workforce to Financials, so FIX(@Relative ("MEMBER_NAME", 0)) wouldn't help too much in that.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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