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

Using Filter in Rules increases the time to calculate in EPCM

edited Aug 27, 2022 1:59AM in Profitability and Cost Management 1 comment

Summary:

When we use a filter for one of the dimensions in the Rule, the time to calculate the rule goes into hours.

Content (required):

We have a model for one of our customers with 7 dimensions including Product (75k members) and Customer (26k members). We have created a flat hierarchy for all the dimensions as the multilevel hierarchy takes a long time to calculate the model.

When we use a filter in the Rule (for deselecting 4 members) for the Customer dimension the time to calculate the rule goes into hours.

Generation time 1 hr 38 min and Calculation time 1 min 13 second

Tried to use an attribute for selecting members but was not able to select all the members of the dimension when the attribute is used to filter the members.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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