Calculation Rules use filters to limit the prefetch size

Calculation rules are updated to include a target filter, based on hierarchy sets, to limit the calculation scope where applicable. This reduces the prefetch size in OLAP reducing initial memory load and improving rule performance.

This applies to most standard Supply calculation rules if the Calculation Scope is 'All Base Elements' and a filter is applicable without affecting the calculation result.

Example:

  • SPLS_FORMULA_TUPLE with sequence 80024. Filter updated:
    • Before: 'pconst'
    • After: 'pconst', %items:{{Set_Hierarchy Set_Items}}, %locations:{{Set_Hierarchy Set_LocationProcesses}}

This feature is enabled after appending the base template (base.zip) and the supply planning template (spls.zip) for this version.

Note: By default, this feature is enabled. No additional role or privilege is required to access this feature.