Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

Hierarchy Expressions

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

Details

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:

    [dimension_name].[hierarchy_name]
    

    Where:

    For example:

    [gend].[h1]
    Copy code to clipboard
  • A reference to a dimension:

    [dimension_name]
    

    For example:

    [gend]
    Copy code to clipboard

    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:

    [relationship_name].hierarchy_expression
    

    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.

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: