| title | Levels (MDX) |
|---|---|
| description | Levels (MDX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | mdx |
Returns the level whose position in a dimension or hierarchy is specified by a numeric expression or whose name is specified by a string expression.
Numeric expression syntax
Hierarchy_Expression.Levels( Level_Number )
String expression syntax
Hierarchy_Expression.Levels( Level_Name )
Hierarchy_Expression
A valid Multidimensional Expressions (MDX) expression that returns a hierarchy.
Level_Number
A valid numeric expression that specifies a level number.
Level_Name
A valid string expression that specifies a level name.
If a level number is specified, the Levels function returns the level associated with the specified zero-based position.
If a level name is specified, the Levels function returns the specified level.
Note
Use the string expression syntax for user-defined functions.
The following examples illustrate each of the Levels function syntaxes.
The following example returns the Country level:
SELECT [Geography].[Geography].Levels(1) ON 0
FROM [Adventure Works]
The following example returns the Country level:
SELECT [Geography].[Geography].Levels('Country') ON 0
FROM [Adventure Works]