KPI Element (CSDLBI)

Important: This document is archived. For the latest information, refer to Open Specification [MS-CSDLBI]: Conceptual Schema Definition File Format with Business Intelligence Annotations.

The Kpi element defines a calculation that you can use as a Key Performance Indicator (KPI). In a business intelligence data model, KPIs are based on measures. The definition of the KPI contains all the metadata associated with measures, as well as information needed for presentation of the KPI values, including a default graphic.

The Kpi element doesn't specify the formula, which is contained in the measure definition. Instead, it specifies the additional metadata that's associated with measures that are used as KPIs. After you designate a measure as a KPI, you can't use it as a measure in other contexts.

Elements and Attributes

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

Name Is Required Description
Documentation No A description of the KPI.
KpiGoal Yes A reference to a column containing values that can be used as the goal.

See PropertyRef Element (CSDLBI).
KpiStatus Yes A reference to a column containing values that represent the current status of the KPI.
StatusGraphic Yes A reference to an image that indicates negative, neutral, or positive progress against the targets defined in the KPI.

Remarks

When you design a model, you can create a KPI by creating a measure and then assigning the measure to use as a KPI. Then add information that's specific to KPIs, such as a graphic to use in showing trends.

Example Tabular

This CSDLBI version 1.0 sample shows a sales KPI from the AdventureWorks tabular model sample.

  
<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>

Example Multidimensional

This CSDLBI version 1.1 sample shows a KPI from the Contoso Operations cube.

<Property Name="Sum_of_SalesAmount" Type="Decimal" Precision="19" Scale="4">  
   <Documentation>  
     <Summary>KPI Description</Summary>  
   </Documentation>  
     <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>  
</Property>
  • Last updated on