This documentation is archived and is not being maintained.

Count (Dimension) (MDX)

Updated: 17 July 2006

Returns the number of hierarchies in a cube.


Dimensions.Count 

Returns the number of hierarchies in a cube, including the [Measures].[Measures] hierarchy.

Example

The following example returns the number of hierarchies in the Adventure Works cube.

WITH MEMBER measures.X AS
  dimensions.count 
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.
Show: