docs.intersystems.com
Home  /  Application Development: Analytics Options  /  InterSystems MDX Reference  /  MDX Statements and Clauses  /  SET Statement


InterSystems MDX Reference
SET Statement
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


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:
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