Condividi tramite

Hierarchy Element (ASSL)

  • Articolo

Defines a hierarchy in a dimension.

Sintassi

<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

Osservazioni

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

Vedere anche

Riferimento

Objects (ASSL)

Guida in linea e informazioni

Assistenza su SQL Server 2005