SET UPDATECALC

Turns Intelligent Calculation on or off.

Syntax

SET UPDATECALC ON | OFF;

Parameters

ON: Essbase calculates only blocks marked as dirty (see Description). Dirty blocks include updated blocks and their dependent parents (see Notes).
OFF: Essbase calculates all data blocks, regardless of whether they have been updated.

Notes

Using Intelligent Calculation, Essbase calculates only dirty blocks, such as updated data blocks and their dependent parents. Therefore, the calculation is very efficient.
All data blocks in the database are marked as either clean or dirty. If a data block is clean, then Essbase knows that the block does not need to be recalculated.
By default, all data blocks are marked as clean after a full calculation of the database but not after a partial calculation of the database. If required, you can change this default behavior using the SET CLEARUPDATESTATUS command in your calculation script.
There are several possible reasons blocks might be marked as dirty. See Understanding Intelligent Calculation for information on Intelligent Calculation and clean and dirty blocks.

Example

SET UPDATECALC ON;

SET UPDATECALC OFF;