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

Dynamic Calc members are not aggregating when CALC DIM is used once

edited Dec 5, 2024 9:12AM in Planning 22 comments

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");

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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