Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.4 / Analytics / InterSystems MDX Reference / Expression Types / Level Expressions
Previous section   Next section

Level Expressions

This section describes how to create and use level expressions in InterSystems MDX.

Details

In InterSystems MDX, a level expression has one of the following forms:
  • A level literal, which is a direct reference to the level as follows:
    [dimension_name].[hierarchy_name].[level_name]
    
    Where:
    • [dimension_name] is an MDX identifier that names a dimension.
    • [hierarchy_name] is an MDX identifier that names a hierarchy within that dimension. You can omit the hierarchy name. If you do, the query uses the first level with the given name, as defined in this dimension.
    • [level_name] is an MDX identifier that names a level within that hierarchy.
    For example:
    [gend].[h1].[gender]
    
  • An expression that uses an InterSystems MDX extension to refer to a level in another cube, via the following syntax:
    [relationship_name].level_expression
    
    Where relationship_name is the name of a relationship in the cube used by the query and level_expression refers to a level contained in that relationship.

Uses

You can use level expressions as arguments to the following MDX functions:
Previous section   Next section