SET UPDATECALC

Turns Intelligent Calculation on or off.

Syntax

SET UPDATECALC ON | OFF;
Parameter Description

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 setting in the essbase.cfg file.

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 the Oracle Essbase Database Administrator's Guide for information on Intelligent Calculation and clean and dirty blocks.

Example

SET UPDATECALC ON;

SET UPDATECALC OFF;

See Also