Hierarchy Element (ASSL)

  • Article

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