MDX Functions that Return a Layer

The following functions return a layer. A layer is used to group the members of a dimension by hierarchical depth.

In Essbase, a layer is either a generation or a level, indicated by a name or a number.

Table 4-30 MDX Layer Functions

Function Result
Generation Returns the generation of the input member.
Generations Returns the generation specified by the input numerical depth and the input dimension or hierarchy.
Level Returns the level of the input member.
Levels Returns the level specified by the input numerical depth and the input dimension or hierarchy.