docs.intersystems.com
Home  /  Application Development: Analytics Options  /  InterSystems MDX Reference  /  Expression Types  /  Hierarchy Expressions


InterSystems MDX Reference
Hierarchy Expressions
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


This section describes how to create and use hierarchy expressions in InterSystems MDX.
Details
In InterSystems MDX, a hierarchy expression has one of the following forms:
Uses
A bare hierarchy expression returns all records; this expression is equivalent to an All member. (Note that you can use a bare hierarchy expression even if the dimension does not formally define an All level.) For example:
SELECT MEASURES.[%count] ON 0, colord.h1 ON 1 FROM patients
 
                             Patient Count
                                      1,000
Also, you can use a hierarchy expression as an argument to any of the following functions: