UPDATECALC

Controls whether Intelligent Calculation is turned on or off by default.

This setting does not apply to aggregate storage databases.

Syntax

UPDATECALC TRUE | FALSE
  • TRUE—Intelligent Calculation is turned on. Essbase calculates only updated blocks and their dependent parents.

  • FALSE—Intelligent Calculation is turned off. Essbase calculates all data blocks, regardless of whether they have been updated.

Description

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, Essbase calculates only updated data blocks and their dependent parents. Therefore, the calculation is very efficient.

Notes

For more information on Intelligent Calculation, see the Oracle Essbase Database Administrator's Guide

Example

UPDATECALC TRUE

In essbase.cfg, a parameter is not followed by a semicolon; in a calculation script, a parameter must be followed by a semicolon.

See Also

SET CLEARUPDATESTATUS (calculation command)

SET UPDATECALC (calculation command)