Turns intelligent calculation on or off.
SET UPDATECALC ON | OFF;
ON | Analytic Services 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 | Analytic Services calculates all data blocks, regardless of whether they have been updated. |
SET UPDATECALC turns intelligent calculation on or off.
Using intelligent calculation, Analytic Services 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 Analytic Services 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 Database Administrator's Guide for information on intelligent calculation and clean and dirty blocks.
SET UPDATECALC ON; SET UPDATECALC OFF;
SET CLEARUPDATESTATUS
UPDATECALC (configuration file setting)
Set Commands
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |