SET UPDATECALC

The SET UPDATECALC calculation command for Essbase 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).

The default setting is ON. You can change this default using the UPDATECALC TRUE | FALSE configuration property.

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;