[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Represents the KPI defined on the OLAP server and stored in the PivotCache.
[Example:
<kpi uniqueName="Growth in Customer Base" caption="Growth in Customer Base"
displayFolder="Customer Perspective\Expand Customer Base"
measureGroup="Internet Sales" value="[Measures].[Growth in Customer Base]"
goal="[Measures].[Growth in Customer Base Goal]"
status="[Measures].[Growth in Customer Base Status]"
trend="[Measures].[Growth in Customer Base Trend]"/>
end example]
|
Parent Elements |
|
kpis (§3.10.1.48) |
|
Attributes |
Description |
|
caption (KPI Display Name) |
Specifies the display name of the KPI.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
displayFolder (KPI Display Folder) |
Specifies the folder where this KPI will be displayed in a list of fields for the PivotTable. This attribute depends on how the application exposes a list of fields in the user interface.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
goal (KPI Goal Unique Name) |
Specifies the unique name of the KPI goal measure.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
measureGroup (KPI Measure Group Name) |
Specifies the name of the measure group to which this KPI belongs.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
parent (Parent KPI) |
Specifies the name of the parent KPI for this KPI.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
status (KPI Status Unique Name) |
Specifies the unique name of the KPI status measure.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
time (Time Member KPI Unique Name) |
Specifies the unique name of the KPI current time member.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
trend (KPI Trend Unique Name) |
Specifies the unique name of the KPI trend measure.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
uniqueName (KPI Unique Name) |
Specifies the unique name of the KPI.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
value (KPI Value Unique Name) |
Specifies the unique name of the KPI value measure.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
weight (KPI Weight Unique Name) |
Specifies the unique name of the KPI weight measure.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_PCDKPI">
<attribute name="uniqueName" use="required" type="ST_Xstring"/>
<attribute name="caption" use="optional" type="ST_Xstring"/>
<attribute name="displayFolder" type="ST_Xstring"/>
<attribute name="measureGroup" type="ST_Xstring"/>
<attribute name="parent" type="ST_Xstring"/>
<attribute name="value" use="required" type="ST_Xstring"/>
<attribute name="goal" type="ST_Xstring"/>
<attribute name="status" type="ST_Xstring"/>
<attribute name="trend" type="ST_Xstring"/>
<attribute name="weight" type="ST_Xstring"/>
<attribute name="time" type="ST_Xstring"/>
</complexType>