Hierarchies Element
Collapse the table of content
Expand the table of content

Hierarchies Element (ASSL)


Applies To: SQL Server 2016 Preview

Contains the collection of Hierarchy elements associated with the parent element.

<Dimension> <!-- or CubeDimension, PerspectiveDimension -->  
            <Hierarchy>...</Hierarchy> <!-- parent: Dimension -->  
      <!-- or -->  
      <Hierarchy xsi:type="CubeHierarchy">...</Hierarchy> <!-- parent: CubeDimension -->  
     <!-- or -->  
      <Hierarchy xsi:type="PerspectiveHierarchy">...</Hierarchy> <!-- parent: PerspectiveDimension -->  

Data type and lengthNone
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
Parent elementsCubeDimension, Dimension, PerspectiveDimension
Child elementsSee the table below.
Ancestor or ParentChild Element
CubeDimensionHierarchy of type CubeHierarchy
PerspectiveDimensionHierarchy of type PerspectiveHierarchy

The corresponding elements in the Analysis Management Objects (AMO) object model are HierarchyCollection, CubeHierarchyCollection, and PerspectiveHierarchyCollection.

Collections (ASSL)

Community Additions

© 2016 Microsoft