Hierarchy Element (CSDL)
The Hierarchy element is a logical container for fields in a table that can be linked to each other to form a hierarchy. The Hierarchy element is derived from the CSDL Property element and has been extended to support the hierarchies created in a tabular model.
The Hierarchy element can have the following child elements (in the order listed):
Documentation Element
Level Element
Applicable Attributes
The following table lists the attributes that can be found on the Hierarchy element. Hierarchies are presented with other columns in the field list for report design, and therefore also have the same attributes as other columns and measures.
Attribute Name |
Is Required |
Value |
|---|---|---|
AllMemberCaption |
No |
The name assigned to the All member of the hierarchy. |
AllMemberReferenceName |
Yes |
The identifier used to reference the All member in a DAX query. |
Caption |
No |
The display name for the hierarchy. |
ContextualNameRule |
No |
A value indicating whether and how the name should be modified based on the context in which it is used. |
DisplayFolder |
No |
The name of the display folder associated with the hierarchy. |
FolderPosition |
No |
An ordinal value indicating the position within its display folder. |
Hidden |
No |
Indicates whether the hierarchy is visible in a client. |
ReferenceName |
No |
The identifier used to reference this entity in a DAX query. |
Remarks
In tabular models, hierarchies are created by specifying parent-child relationships among columns in the same table. For more information about how to create hierarchies in tabular models, see Hierarchies (SSAS Tabular).
Example
The following example shows a hierarchy that is defined in the Date table.
<bi:Hierarchy>
<bi:Level>
<bi:Source>
<bi:PropertyRef name="Calendar_Year" />
</bi:Source>
</bi:Level>
<bi:Level>
<bi:Source>
<bi:PropertyRef name="Calendar_Semester" />
</bi:Source>
</bi:Level>
<bi:Level>
<bi:Source>
<bi:PropertyRef name="Calendar_Quarter" />
</bi:Source>
</bi:Level>
<bi:Level>
<bi:Source>
<bi:PropertyRef name="Month_Calendar" />
</bi:Source>
</bi:Level>
<bi:Level>
<bi:Source>
<bi:PropertyRef name="Day_Of_Month" />
</bi:Source>
</bi:Level>
</bi:Hierarchy>
See Also
Concepts
Understanding the Tabular Object Model