PivotCacheDefinition class
Defines the PivotCacheDefinition Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:pivotCacheDefinition.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.PivotCacheDefinition
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
2.4.20 pivotCacheDefinition
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
A pivotCacheDefinition element is a CT_PivotCacheDefinition type element, as specified in section 2.6.33, that specifies the extended properties of a PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, PivotCache definition. See section 2.2.4.5 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="pivotCacheDefinition" type="CT_PivotCacheDefinition"/>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.33 CT_PivotCacheDefinition
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: pivotCacheDefinition
A complex type that specifies the extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache definition.
Attributes:
slicerData: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the Slicer Cache Relationship to PivotCache. MUST be "true" if the OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache definition is being referenced by a slicer cache.
pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute which uniquely identifies this PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache. MUST not be zero if there is a slicer cache that uses this PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache as a data source (1). MUST be greater than or equal to zero. MUST not be zero if there is a CT_PivotCacheIdVersion element that is preceded by this element.
supportSubqueryNonVisual: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable ([ISO/IEC-29500-1] section 18.10) supports hidden PivotTable items.
supportSubqueryCalcMem: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.
supportAddCalcMems: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC-29500-1] section 18.10) calculated members are shown for filtering.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_PivotCacheDefinition">
<xsd:attribute name="slicerData" type="xsd:boolean" use="optional" default="false"/>
<xsd:attribute name="pivotCacheId" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="supportSubqueryNonVisual" type="xsd:boolean" use="optional" default="false"/>
<xsd:attribute name="supportSubqueryCalcMem" type="xsd:boolean" use="optional" default="false"/>
<xsd:attribute name="supportAddCalcMems" type="xsd:boolean" use="optional" default="false"/>
</xsd:complexType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).