Levels (MDX)

 

Updated: March 2, 2016

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.

System_CAPS_ICON_note.jpg Note


Use the string expression syntax for user-defined functions.

The following examples illustrate each of the Levels function syntaxes.

Numeric

The following example returns the Country level:

SELECT [Geography].[Geography].Levels(1) ON 0  
FROM [Adventure Works]  

String

The following example returns the Country level:

SELECT [Geography].[Geography].Levels('Country') ON 0  
FROM [Adventure Works]  

MDX Function Reference (MDX)

Community Additions

ADD
Show: