Hierarchy Element (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Defines a hierarchy in a dimension.


   <Hierarchy xsi:type="Hierarchy">...</Hierarchy> <!-- ancestor: Dimension -->  
   <!-- or -->  
   <Hierarchy xsi:type="CubeHierarchy">...</Hierarchy> <!-- ancestor: CubeDimension -->  
   <!-- or -->  
   <Hierarchy xsi:type="PerspectiveHierarchy">...</Hierarchy> <!-- ancestor: PerspectiveDimension -->  
   <!-- or -->  
   <Hierarchy xsi:type="MeasureGroupHierarchy">...</Hierarchy> <!-- ancestor: RegularMeasureGroupDimension -->  

Element Characteristics

Characteristic Description
Data type and length See the table below.
Default value None
Cardinality 0-n: Optional element that can occur more than once.
Ancestor or Parent Data Type
Dimension Hierarchy
CubeDimension CubeHierarchy
PerspectiveDimension PerspectiveHierarchy
RegularMeasureGroupDimension MeasureGroupHierarchy

Element Relationships

Relationship Element
Parent elements Hierarchies
Child elements None


The corresponding elements in the Analysis Management Objects (AMO) object model are Hierarchy, CubeHierarchy, and PerspectiveHierarchy.

See Also

Objects (ASSL)