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 |
|