Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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>