TechNet
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

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:
© 2016 Microsoft