Returns the level specified by the input level number.
Syntax
dimension.Levels ( index )
Levels ( dimension, index )
Parameter | Description |
---|---|
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:
(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 |
See Also