count-dimension-mdx.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Count (Dimension) (MDX)	Count (Dimension) (MDX)	kfollis	kfollis	kfollis	02/17/2022	sql	analysis-services	reference	mdx

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

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