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

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft