Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

Hierarchy Expressions

This section describes how to create and use hierarchy expressions in DeepSee MDX.


In DeepSee MDX, a hierarchy expression has one of the following forms:

  • A hierarchy literal, which is a direct reference to the hierarchy as follows:



    For example:

  • A reference to a dimension:


    For example:


    DeepSee interprets this as a reference to the first visible hierarchy of that dimension.

  • An expression that uses a DeepSee MDX extension to refer to a hierarchy in another cube, via the following syntax:


    Where relationship_name is the name of a relationship in the cube used by the query and hierarchy_expression refers to a hierarchy contained in that relationship.


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

Also, you can use a hierarchy expression as an argument to any of the following functions: