SET UPDATECALC

The SET UPDATECALC command turns intelligent calculation on and off.

SET UPDATECALC ON | OFF;

ON Hyperion 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 Hyperion Essbase calculates all data blocks, regardless of whether they have been updated.

Description

SET UPDATECALC turns intelligent calculation on and off.

Using intelligent calculation, Hyperion 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 Hyperion 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 calc script.

Notes

There are several possible reasons blocks might be marked as dirty. See the Database Administrator's Guide for information on intelligent calculation and clean and dirty blocks.

Example

SET UPDATECALC ON;

SET UPDATECALC OFF;

See Also

SET CLEARUPDATESTATUS
UPDATECALC (ESSBASE.CFG file)

ON	Hyperion 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	Hyperion Essbase calculates all data blocks, regardless of whether they have been updated.