Avoiding Using Dynamic Members as Drivers

If a driver value requires a formula, it is best to calculate the value before allocation rules are executed. During rule execution, every possible destination location is reviewed by the rule to determine what the driver value is at that location. If a calculated member is referenced as the driver, then the system must execute the member formula for every possible location. This can result in potentially billions of unnecessary computations which severely impact rule performance.

A better solution is to prepare driver data for the rule by preceding it with a custom calculation rule to execute the formula needed and store the driver value in a stored member. This allows the allocation rule to execute normally and quickly skip locations without any driver data.