Using Filter in Rules increases the time to calculate in EPCM
When we use a filter for one of the dimensions in the Rule, the time to calculate the rule goes into hours.
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.