Hierarchy Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines a hierarchy in a dimension.

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

CharacteristicDescription
Data type and lengthSee the table below.
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Ancestor or ParentData Type
DimensionHierarchy
CubeDimensionCubeHierarchy
PerspectiveDimensionPerspectiveHierarchy
RegularMeasureGroupDimensionMeasureGroupHierarchy
RelationshipElement
Parent elementsHierarchies
Child elementsNone

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

Objects (ASSL)

Community Additions

ADD
Show: