hierarchy-element-assl.md

title	Hierarchy Element (ASSL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	Hierarchy Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	Hierarchy
helpviewer_keywords	Hierarchy element
ms.assetid	ac54d74a-5e6c-4c24-83bf-766440478f6c
caps.latest.revision	38
author	Minewiskan
ms.author	owend
manager	erikre

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	See the table below.
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Ancestor or Parent	Data Type
Dimension	Hierarchy
CubeDimension	CubeHierarchy
PerspectiveDimension	PerspectiveHierarchy
RegularMeasureGroupDimension	MeasureGroupHierarchy

Element Relationships

Relationship	Element
Parent elements	Hierarchies
Child elements	None

Remarks

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

See Also

Objects (ASSL)