Using Dimension, Hierarchy, and Level Functions
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)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for