Using Dimension, Hierarchy, and Level Functions

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Dimension, hierarchy, and level functions are useful for traversing the multidimensional structures found in Analysis Services. Typically, you use such functions in conjunction with other functions to obtain information about the members of a dimension, hierarchy, or level.

The following example shows how to use the .Dimension, .Hierarchy, and .Level functions:

WITH

MEMBER MEASURES.DIMENSIONNAME AS [Date].[Calendar].CURRENTMEMBER.DIMENSION.NAME

MEMBER MEASURES.HIERARCHYNAME AS [Date].[Calendar].CURRENTMEMBER.HIERARCHY.NAME

MEMBER MEASURES.LEVELNAME AS [Date].[Calendar].LEVEL.NAME

SELECT

{MEASURES.DIMENSIONNAME, MEASURES.HIERARCHYNAME, MEASURES.LEVELNAME}

ON Columns,

[Date].[Calendar].MEMBERS

ON Rows

FROM [Adventure Works]

See Also

Dimension (MDX)
Functions (MDX Syntax)
Hierarchy (MDX)
Level (MDX)