Dimensions (MDX)

 

Updated: March 2, 2016

Returns a hierarchy specified by a numeric or string expression.

  
Numeric expression syntax  
Dimensions(Hierarchy_Number)  
  
String expression syntax  
Dimensions(Hierarchy_Name)  

Hierarchy_Number
A valid numeric expression that specifies a hierarchy number.

Hierarchy_Name
A valid string expression that specifies a hierarchy name

If a hierarchy number is specified, the Dimensions function returns a hierarchy whose zero-based position within the cube is specified hierarchy number.

If a hierarchy name is specified, the Dimensions function returns the specified hierarchy. Typically, you use this string version of the Dimensions function with user-defined functions.

System_CAPS_ICON_note.jpg Note


The Measures dimension is always represented by Dimensions(0).

The following examples use the Dimensions function to return the name, count of levels, and count of members of a specified hierarchy, using both a numeric expression and a string expression.

WITH MEMBER Measures.x AS Dimensions  
   ('[Product].[Product Model Lines]').Name  
SELECT Measures.x on 0  
FROM [Adventure Works]  
  
WITH MEMBER Measures.x AS Dimensions  
   ('[Product].[Product Model Lines]').Levels.Count  
SELECT Measures.x on 0  
FROM [Adventure Works]  
  
WITH MEMBER Measures.x AS Dimensions  
   ('[Product].[Product Model Lines]').Members.Count  
SELECT Measures.x on 0  
FROM [Adventure Works]  
  
WITH MEMBER Measures.x AS Dimensions(0).Name  
SELECT Measures.x on 0  
FROM [Adventure Works]  
  
WITH MEMBER Measures.x AS Dimensions(0).Levels.Count  
SELECT measures.x on 0  
FROM [Adventure Works]  
  
WITH MEMBER Measures.x AS Dimensions(0).Members.Count  
SELECT measures.x on 0  
FROM [Adventure Works]  

MDX Function Reference (MDX)

Community Additions

ADD
Show: