1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. UPDATECALC

UPDATECALC

The UPDATECALC configuration setting enables you to set whether Essbase's Intelligent Calculation feature is on or off. By default, Intelligent Calculation is on for block storage (BSO) cubes, meaning that Essbase calculates only updated blocks and their dependent parents.

This setting does not apply to aggregate storage cubes.

Syntax

UPDATECALC TRUE | FALSE

  • TRUE—Intelligent Calculation is turned on. Essbase calculates only updated blocks and their dependent parents. This is the default.

  • 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.

Example

UPDATECALC TRUE

See Also

SET CLEARUPDATESTATUS (calculation command)

SET UPDATECALC (calculation command)