SET Commands

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

See Also

Example

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

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

In the following example, Analytic Services calculates member combinations for Qtr1 with the SET AGGMISSG setting turned on. Analytic Services 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 Database Administrator's Guide.

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com