using-dimension-hierarchy-and-level-functions.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Using Dimension, Hierarchy, and Level Functions	Using Dimension, Hierarchy, and Level Functions	kfollis	kfollis	kfollis	02/17/2022	sql	analysis-services	reference	mdx

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)