Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Levels (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 Note

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]
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.