SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Analysis Services
Technical Reference
Query and Expression Language Reference
Multidimensional Expressions (MDX) Reference
MDX Language Reference
MDX Function Reference
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ancestors
Ascendants
Avg
Axis
BottomCount
BottomPercent
BottomSum
CalculationCurrentPass
CalculationPassValue
CASE Statement
Children
ClosingPeriod
CoalesceEmpty
Correlation
Count (Dimension)
Count (Hierarchy Levels)
Count (Set)
Count (Tuple)
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentMember
CurrentOrdinal
CustomData
DataMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctCount
Divide
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
Error
Except
Exists
Extract
Filter
FirstChild
FirstSibling
Generate
Head
Hierarchize
Hierarchy
IIf
Instr
Intersect
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item (Member)
Item (Tuple)
KPIGoal
KPIStatus
KPITrend
KPIWeight
KPICurrentTimeMember
KPIValue
Lag
LastChild
LastPeriods
LastSibling
Lead
Leaves
Level
Levels
LinkMember
LinRegIntercept
LinRegPoint
LinRegR2
LinRegSlope
LinRegVariance
LookupCube
Max
MeasureGroupMeasures
Median
Members (Set)
Members (String)
MemberToStr
MemberValue
Min
Mtd
Name
NameToSet
NextMember
NonEmpty
NonEmptyCrossjoin
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
Predict
PrevMember
Properties
Qtd
Rank
RollupChildren
Root
SetToArray
SetToStr
Siblings
Stddev
StddevP
Stdev
StdevP
StripCalculatedMembers
StrToMember
StrToSet
StrToTuple
StrToValue
Subset
Sum
Tail
This
ToggleDrillState
TopCount
TopPercent
TopSum
TupleToStr
Union
UniqueName
UnknownMember
Unorder
UserName
ValidMeasure
Value
Var
Variance
VarianceP
VarP
VisualTotals
Wtd
Ytd
Expand Minimize
This topic has not yet been rated - Rate this topic

Count (Dimension) (MDX)

SQL Server 2012

Returns the number of hierarchies in a cube.

Copy 

Dimensions.Count

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.

Copy 
WITH MEMBER measures.X AS
  dimensions.count 
SELECT Measures.X ON 0
FROM [Adventure Works]
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.