Level

Returns the level of the input member.

Syntax

member.Level
ParameterDescription

member

A member specification.

Example

The following query

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

returns the grid:

(axis)Qtr1Qtr2Qtr3Qtr4
100-105096589265835206
100-201359153415281287
100-30593446400544
200-101697173418831887
200-202963307931492834
200-301153123111591093
200-409089868141384
300-102544323133553065
300-20690815488518
300-302695272328552820
400-102838299832012807
400-202283252226422404
400-30-116-84-145-49
100-201359153415281287
200-202963307931492834
300-302695272328552820

See Also