Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Best way to move data bso to aso for level 0 dynamic calc members in account hierarchy

in Planning 4 comments

In epm cloud planning, how to move data between data from bso to aso for a dynamic calc account dimension member with formula as below?

@@SUMRANGE("I_4-7",@INTERSECT(@ATTRIBUTE("AttrDim_CC_Function_1_CDC_AC"), @RELATIVE(@CURRMBR("Cost Center"),0)));

For me it seems

  1. To write mdx in aso for the dynamic calc members
  2. To create another account as stored in bso and push this account member from bso to aso using data maps

Any suggestions / best practices.

Also any pointers for writing this complex member formula of bso to aso as mdx that uses attribute dimensions across the cost center ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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