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.