Hierarchy Element (ASSL)

Defines a hierarchy in a dimension.

Syntax

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

Element Characteristics

Characteristic

Description

Data type and length

Ancestor or Parent

Data Type

DimensionHierarchy

CubeDimensionCubeHierarchy

PerspectiveDimensionPerspectiveHierarchy

RegularMeasureGroupDimensionMeasureGroupHierarchy

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Hierarchies
Child elements	None

Remarks

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

See Also

Reference

Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance