Level
The MDX Level function for Essbase returns the level of the input member.
Syntax
member.LevelParameters
- member
-
A member specification.
Example
The following query
SELECT
[Year].[Qtr1].Level.Members
ON COLUMNS,
[Product].Levels(0).Members
ON ROWS
FROM Sample.Basicreturns the grid:
Table 4-108 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 |
| 200-30 | 1153 | 1231 | 1159 | 1093 |
| 200-40 | 908 | 986 | 814 | 1384 |
| 300-10 | 2544 | 3231 | 3355 | 3065 |
| 300-20 | 690 | 815 | 488 | 518 |
| 300-30 | 2695 | 2723 | 2855 | 2820 |
| 400-10 | 2838 | 2998 | 3201 | 2807 |
| 400-20 | 2283 | 2522 | 2642 | 2404 |
| 400-30 | -116 | -84 | -145 | -49 |
| 100-20 | 1359 | 1534 | 1528 | 1287 |
| 200-20 | 2963 | 3079 | 3149 | 2834 |
| 300-30 | 2695 | 2723 | 2855 | 2820 |