Specifying Global Settings for a Database Calculation

Table 84 lists the commands that define calculation behavior:

Table 84. List of Commands for Defining Calculation Behavior

Command

Calculation

SET AGGMISSG

Specify how Essbase treats #MISSING values during a calculation

SET CACHE

Adjust the default calculator cache size

SET CALCPARALLEL

Enable parallel calculation (see Using Parallel Calculation)

SET CALCTASKDIMS

Increase the number of dimensions used to identify tasks for parallel calculation (see Using Parallel Calculation)

SET FRMLBOTTOMUP

Optimize the calculation of sparse dimension formulas in large database outlines (see Optimizing Formulas on Sparse Dimensions in Large Database Outlines)

SET MSG

SET NOTICE

Display messages to trace a calculation

SET UPDATECALC

Turn on and turn off Intelligent Calculation (see Turning Intelligent Calculation On and Off)

SET CLEARUPDATESTATUS

Control how Essbase marks data blocks for Intelligent Calculation (see Using the SET CLEARUPDATESTATUS Command)

SET LOCKBLOCK

Specify the maximum number of blocks that Essbase can lock concurrently when calculating a sparse member formula

SET CREATEBLOCKEQ

Turn on and turn off the Create Blocks on Equation setting, which controls the creation of blocks when you assign nonconstant values to members of a sparse dimension (see Nonconstant Values Assigned to Members in a Sparse Dimension)

SET CREATENONMISSINGBLK

Enable calculations on potential data blocks and save these blocks when the result is not #MISSING

SET UPTOLOCAL

For currency conversions, restrict consolidations to parents that have the same defined currency (see Calculating Databases)

A SET command in a calculation script stays in effect until the next occurrence of the same SET command.

In the following calculation script, Essbase displays messages at the detail level (SET MSG DETAIL;) when calculating the Year dimension and displays messages at the summary level (SET MSG SUMMARY;) when calculating the Measures dimension:

SET MSG DETAIL;
CALC DIM(Year);

SET MSG SUMMARY;

CALC DIM(Measures);

Some SET calculation commands trigger additional passes through the database.

In the following calculation script, Essbase calculates member combinations for Qtr1 with SET AGGMISSG turned on, and then does a second calculation pass through the database and calculates member combinations for East with SET AGGMISSG turned off:

SET AGGMISSG ON;
Qtr1;
SET AGGMISSG OFF;

East;

Also see Using Two-Pass Calculation.