Count (Dimension) (MDX)

Returns the number of hierarchies in a cube.

Syntax

Dimensions.Count 

Remarks

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]

See Also

Reference

Count (Tuple) (MDX)
Count (Hierarchy Levels) (MDX)
Count (Set) (MDX)
MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.