Table 84 lists the commands that define calculation behavior:
Table 84. List of Commands for Defining Calculation Behavior
Specify how Essbase treats #MISSING values during a calculation | |
Enable parallel calculation (see Using Parallel Calculation) | |
Increase the number of dimensions used to identify tasks for parallel calculation (see Using Parallel Calculation) | |
Optimize the calculation of sparse dimension formulas in large database outlines (see Optimizing Formulas on Sparse Dimensions in Large Database Outlines) | |
Turn on and turn off Intelligent Calculation (see Turning Intelligent Calculation On and Off) | |
Control how Essbase marks data blocks for Intelligent Calculation (see Using the SET CLEARUPDATESTATUS Command) | |
Specify the maximum number of blocks that Essbase can lock concurrently when calculating a sparse member formula | |
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) | |
Enable calculations on potential data blocks and save these blocks when the result is not #MISSING | |
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.