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.

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

Understanding Functions for Parent-Child Hierarchies in DAX

Configure the (All) Level for Attribute Hierarchies