Levels

The MDX Levels function for Essbase returns the level specified by the input level number.

Syntax

dimension.Levels ( index )

Levels ( dimension, index )

Parameters

dimension: The dimension specification.
index: The number of steps up from the lowest level-0 member of the dimension. The count begins with zero at leaf members.

Example

The following query

SELECT
 [Year].[Qtr1].Level.Members
ON COLUMNS,
 [Product].Levels(0).Members
ON ROWS
FROM Sample.Basic

returns the grid:

Table 4-109 Output Grid from MDX Example

(axis)	Qtr1	Qtr2	Qtr3	Qtr4
100-10	5096	5892	6583	5206
100-20	1359	1534	1528	1287
100-30	593	446	400	544
200-10	1697	1734	1883	1887
200-20	2963	3079	3149	2834
...	...	...	...	...
300-30	2695	2723	2855	2820