Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Levels (MDX)

Updated: 17 July 2006

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.

ms144796.note(en-US,SQL.90).gifNote:
Use the string expression syntax for user-defined functions.

Examples

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]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.

Community Additions

ADD
Show:
© 2015 Microsoft