This topic has not yet been rated - Rate this topic

KpiStatus Element (CSDL)

SQL Server 2012

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>

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD