[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Represents the collection of Key Performance Indicators (KPIs) defined on the OLAP server and stored in the PivotCache.
[Example:
<kpis count="3">
<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]"/>
<kpi uniqueName="Net Income" caption="Net Income"
displayFolder="Financial Perspective\Maintain Overall Margins"
measureGroup="Financial Reporting" value="[Measures].[Net Income Value]"
goal="[Measures].[Net Income Goal]" status="[Measures].[Net Income Status]"
trend="[Measures].[Net Income Trend]"/>
<kpi uniqueName="Operating Profit" caption="Operating Profit"
displayFolder="Financial Perspective\Maintain Overall Margins"
measureGroup="Financial Reporting" parent="Net Income"
value="[Measures].[Operating Profit Value]"
goal="[Measures].[Operating Profit Goal]"
status="[Measures].[Operating Profit Status]"
trend="[Measures].[Operating Profit Trend]"/>
…
end example]
Parent Elements |
pivotCacheDefinition (§3.10.1.67) |
Child Elements |
Subclause |
kpi (OLAP KPI) |
§3.10.1.47 |
Attributes |
Description |
count (KPI Count) |
Specifies the number of KPIs stored in the PivotCache.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_PCDKPIs">
<sequence>
<element name="kpi" minOccurs="0" maxOccurs="unbounded" type="CT_PCDKPI"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt"/>
</complexType>