InterSystems IRIS Data Platform 2019.2  /  InterSystems MDX Reference  /  MDX Statements and Clauses

InterSystems MDX Reference
CREATE SET Statement
Previous section           Next section
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

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-09-19 06:44:29