Share via

KpiStatus Element (CSDL)

  • Article

The KpiStatus element defines the value that is used as the status indicator in a Key Performance Indicator (KPI). The status value is a normalized value between -1 and 1.

The KpiStatus element appears only as a child element of the KPI element, and can have the following child elements (in the order listed):

  • Documentation element

Applicable Attributes

The table below describes the attributes that can be found on the KpiStatus element.

Attribute Name

Is Required

Value

PropertyRef

Yes

A reference to a column that contains the value.

Example

The following sample shows a KPI from the AdventureWorks tabular model sample. Rather than specify a value, the element refers to a column that contains the value.

<bi:Measure Caption="Total Current Quarter Margin Performance" ReferenceName="Total Current Quarter Margin Performance" Width="0" IsSimpleMeasure="false">
  <bi:Kpi StatusGraphic="Three Symbols UnCircled Colored">
    <bi:KpiGoal>
      <bi:PropertyRef Name="Measures___Total_Current_Quarter_Margin_Performance_Goal_" />
    </bi:KpiGoal>
    <bi:KpiStatus>
      <bi:PropertyRef Name="Measures___Total_Current_Quarter_Margin_Performance_Status_" />
    </bi:KpiStatus>
  </bi:Kpi>
</bi:Measure>