SET Commands

The SET calculation commands for Essbase are procedural. The first occurrence of a SET command in a calculation script stays in effect until the next occurrence of the same SET command.

Example

In the following example, Essbase displays messages at the DETAIL level when calculating the Year dimension. However, when calculating the Measures dimension, Essbase displays messages at the SUMMARY level.

SET MSG DETAIL;CALC DIM(Year);
SET MSG SUMMARY;CALC DIM(Measures);
 

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

SET AGGMISSG ON;Qtr1;
SET AGGMISSG OFF;East;