Share via

KpiGoal Element (CSDL)

  • Article

The KpiGoal element defines the target value that is used to define a Key performance Indicator (KPI). In a tabular model, 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.

The KpiGoal element can appear 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 KpiGoal element.

Attribute Name

Is Required

Value

TPropertyRef

Yes

A reference to the column that contains the KPI goal value.

Remarks

When you create a model, you can create a KPI by creating a measure and then assigning the measure to use as a KPI. You then add information that is specific to KPIs, such as a graphic to use in showing trends. For more information about creating KPIs, see KPIs (SSAS Tabular).

Example

The following sample shows a KPI from the Adventureworks sample model.

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