SET commands in a calculation script 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. For more information on calculation passes, see the Oracle Essbase Database Administrator's Guide.
SET AGGMISSG ON;Qtr1; SET AGGMISSG OFF;East;