Kpis Class
OLAP KPIs.When the object is serialized out as xml, its qualified name is x:kpis.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.Kpis
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(Kpi))> _
Public Class Kpis _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As Kpis
[ChildElementInfoAttribute(typeof(Kpi))]
public class Kpis : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- Kpi <x:kpi>
[ISO/IEC 29500-1 1st Edition]
18.10.1.48 kpis (OLAP KPIs)
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 (§18.10.1.67) |
Child Elements |
Subclause |
|---|---|
kpi (OLAP KPI) |
§18.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 W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_PCDKPIs) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.