MDX Functions that Return a Layer

The following MDX 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.