1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Function Return Values
  4. MDX Functions that Return a Layer

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.