Controls whether intelligent calculation is turned on or off by default.
This setting does not apply to aggregate storage databases.
UPDATECALC TRUE | FALSE
TRUE | Intelligent calculation is turned on. Analytic Services calculates only updated blocks and their dependent parents. |
FALSE | Intelligent calculation is turned off. Analytic Services calculates all data blocks, regardless of whether they have been updated. |
UPDATECALC specifies whether intelligent calculation is turned on or off by default.
If required during a calculation, you can override this default setting and turn intelligent calculation on and off using the SET UPDATECALC command in a calculation script.
Using intelligent calculation, Analytic Services calculates only updated data blocks and their dependent parents. Therefore, the calculation is very efficient.
For more information on intelligent calculation, see the Database Administrator's Guide.
UPDATECALC TRUE UPDATECALC FALSE
In essbase.cfg
, a parameter is not followed by a semicolon; in a calculation script, a parameter must be followed by a semicolon.
SET CLEARUPDATESTATUS
(calculation command)
SET UPDATECALC
(calculation command)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |