Benefits of Intelligent Calculation

Intelligent Calculation is designed to provide significant calculation performance benefits for these types of calculations:

• A full calculation of a database (CALC ALL), with some exceptions.

  See Limitations of Intelligent Calculation.

• A calculation script that calculates all members in one CALC DIM statement.

• For database calculations that cannot use Intelligent Calculation for the full calculation, you may be able to use Intelligent Calculation for part of the calculation.

  For example, to significantly improve calculation performance for a case in which you calculate a database by doing a default consolidation and then an allocation of data, enable Intelligent Calculation for the default consolidation and then disable Intelligent Calculation for the allocation.

  Assuming that Intelligent Calculation is turned on (the default), create a calculation script to perform these steps for a partial Intelligent Calculation:

  • Enable Intelligent Calculation, if it is disabled

  • Use CALC ALL to calculate the database

  • Use the SET UPDATECALC command to disable Intelligent Calculation

  • Allocate data

  • Optionally, enable Intelligent Calculation again