Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Level
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content

Level (MDX)

Updated: 17 July 2006

Returns the level of a member.


Member_Expression.Level

Member_Expression

A valid Multidimensional Expression (MDX) that returns a member.

Examples

The following example uses the Level function to return the default measure for all months in the Adventure Works cube.

SELECT[Date].[Fiscal].[Month].[February 2002].Level ON 0
FROM [Adventure Works]

The following example uses the Level function to return the name of the level for the All-Purpose Bike Stand in the Model Name attribute hierarchy in the Adventure Works cube.

WITH MEMBER Measures.x AS 
   [Product].[Model Name].[All-Purpose Bike Stand].Level.Name
SELECT Measures.x ON 0
FROM [Adventure Works]

The following example uses the Level function to return the name of the level for the All-Purpose Bike Stand in the Product Model Categories user-defined hierarchy in the Adventure Works cube.

WITH MEMBER Measures.x AS 
   [Product].[Product Model Categories].[Model].
      [All-Purpose Bike Stand].Level.Name
SELECT Measures.x 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