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