AllRuleCalcStargateOptimization

The AllRuleCalcStargateOptimization parameter can improve performance in calculating views that contain only rule-calculated values. In some unique cases, enabling this parameter can result in performance degradation, so you should test the effect of the parameter in a development environment before deploying to your production environment.

Parameter type: optional, static

Important: AllRuleCalcStargateOptimization is applicable only to models that do not use alternate hierarchies. Enabling this parameter for models that do use alternate hierarchies will cause null suppression and other undesirable effects.

Typically, Planning Analytics performs calculations for standard consolidations and then calculates values for rule-based consolidations, which may end up overriding values in the standard consolidations. The AllRuleCalcStargateOptimization parameter provides optimization that first checks if every value in the view is rule-calculated and then proceeds as follows:

  • If every value in the view is rule-calculated, then Planning Analytics skips the unnecessary calculations for standard consolidations and just performs the rule-calculated consolidations.
  • If the view contains even a single value which is not rule-calculated, then this optimization parameter will have no effect.
  • If the view includes alternate hierarchies, then this optimization parameter will have no effect.

When this parameter is set to True, some additional processing will take place for every view that is requested to first check if the view contains only rule-calculated values. For most views, this additional processing is minimal since the optimization is stopped after the first value in the view is found to be not rule-calculated.

To enable this parameter, set the parameter's value to T in the Planning Analytics database configuration, as follows:

AllRuleCalcStargateOptimization=T

The default setting is disabled (F).