Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Using Filter in Rules increases the time to calculate in EPCM — Cloud Customer Connect
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

Received Response
21
Views
2
Comments
edited Aug 27, 2022 1:59AM in Profitability and Cost Management 2 comments

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!