KpiGoal 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 KpiGoal element provides a reference to the column that is used to define the goal for a Key performance Indicator (KPI).

In CSDLBI, KPIs are based on measures, and the Measure element contains the formula (if any), while other metadata associated with the KPI are defined as part of the KPI Element (CSDLBI). The Kpigoal element is a subtype of the Kpi element.

Elements and Attributes

The following table lists the attributes that define the KpiGoal element.

Name Is Required Description
PropertyRef Yes A reference to the column that contains the KPI goal value.

The Kpigoal element must contain exactly one PropertyRef element.

See PropertyRef Element (CSDLBI).

Example Tabular

The following sample, in CSDLBI version 1.1, shows a KPI from the Adventureworks sample model.

  
<Property Name="InternetCurrentSalesPerformance" 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

The following sample, in CSDLBI version 1.1, shows a KPI from the Contoso Operations cube.

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