Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.3 / Application Development / InterSystems MDX Reference / MDX Statements and Clauses / SET Statement
Previous section   Next section

SET Statement

Creates a pivot variable for use in the current session, for the purpose of development. This statement is available only in the MDX shell.

Syntax and Details

SET variable_name variable_value
Where:
  • variable_name is the name of the pivot variable (without the leading $variable. syntax). The name is not case-sensitive; the system ignores the case when you refer to the variable. You cannot create multiple variables with names that differ only in case.
    Note that this pivot variable is independent of any cube and is available only for use within the current shell session.
  • variable_value is the value of the pivot variable.
    For information on pivot variables, see “Defining and Using Pivot Variables” in Using the Analyzer.

Examples

The following MDX shell session provides an example:
>>set mypivotvar colord.red
mypivotvar is: colord.red
>>select $variable.mypivotvar on 0 from patients
 
                                       Red
                                        129
Previous section   Next section