Level Element (CSDL)
The Level element defines the data source of a single attribute in a hierarchy
The Level element can have the following child elements (in the order listed):
Documentation Element
SourceProperty Element
Applicable Attributes
The following table lists the attributes that can be found on the Level element.
Attribute Name |
Is Required |
Value |
|---|---|---|
ReferenceName |
Yes |
The identifier used to reference the level in a DAX query. |
Caption |
No |
The display name for the level. |
Remarks
For more information about hierarchies in tabular models, see Hierarchy Element (CSDL).
Example
The following example shows the definition of multiple levels in a hierarchy from the AdventureWorks tabular model sample.
<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>
<bi:Hierarchy>
See Also
Concepts
Understanding the Tabular Object Model