Home  /  Application Development: Analytics Options  /  InterSystems MDX Reference  /  MDX Statements and Clauses  /  CREATE SET Statement

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

Creates a named set that can be used within the current session.
Syntax and Details
CREATE SESSION SET cube_name.set_name AS 'set_expression'
When you use the MDX shell, a session is started; the session ends when you exit the shell. During this session, if you use the CREATE SET statement, the member that you create is available until the session ends or until you use the DROP SET statement.
First, in the MDX shell, we define a new named set in the Patients cube:
>>CREATE SESSION SET patients.testset AS 'birthd.decade.MEMBERS'
Elapsed time:       .014451s
Then we use the named set in a query:
>>SELECT MEASURES.[%COUNT] ON 0, testset ON 1 FROM patients
                             Patient Count
 1 1910s                                 71
 2 1920s                                223
 3 1930s                                572
 4 1940s                                683
 5 1950s                              1,030
 6 1960s                              1,500
 7 1970s                              1,520
 8 1980s                              1,400
 9 1990s                              1,413
10 2000s                              1,433
11 2010s                                155
Elapsed time:       .018745s
See Also