Export (0) Print
Expand All

KpiStatus Element (CSDLBI)

The KpiStatus element defines a reference to the column that contains the value used as the status indicator in a Key Performance Indicator (KPI).

The following table lists the elements and attributes that define the KpiStatus element.

Name

Is Required

Description

PropertyRef

Yes

A reference to a column that contains the value used as the status indicator in a KPI.

This element MUST contain exactly one column reference, as defined by the TPropertyRefcomplex type.

Tabular

The following sample, in CSDLBI version 1.1, shows a KPI from the AdventureWorks tabular model sample. The KpiStatus element refers to a column (represented as a PropertyRef) that contains the value.

<Property Name="InternetCurrSalesPerf" Type="Double">
   <bi:Measure>
     <bi:Kpi StatusGraphic="Three Stars Colored">
       <bi:KpiGoal>
         <bi:PropertyRef Name="v_InternetCurrSalesPerf_Goal" />
       </bi:KpiGoal>
       <bi:KpiStatus>
         <bi:PropertyRef Name="v_InternetCurrSalesPerf_Status" />
       </bi:KpiStatus>
     </bi:Kpi>
   </bi:Measure>
</Property>

Multidimensional

The following sample, in CSDLBI version 1.1, shows a KPI from the Contoso Operations cube. The KpiStatus element references a measure that calculates the value for the KPI status.

<bi:Measure 
       Caption="Sum of SalesAmount" 
       ReferenceName="Sum of SalesAmount" 
       FormatString="\$#,0.00;(\$#,0.00);\$#,0.00">

    <bi:Kpi 
       StatusGraphic="Three Circles Colored">

      <bi:KpiGoal>
         <bi:PropertyRef 
          Name="v_Sum_of_SalesAmount_Goal" />
       </bi:KpiGoal>

       <bi:KpiStatus>
          <bi:PropertyRef 
          Name="v_Sum_of_SalesAmount_Status" />
        </bi:KpiStatus>

       </bi:Kpi>
</bi:Measure>

Community Additions

ADD
Show:
© 2014 Microsoft