PivotCacheDefinition Class
Defines the PivotCacheDefinition Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:pivotCacheDefinition.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.PivotCacheDefinition
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class PivotCacheDefinition _
Inherits OpenXmlLeafElement
'Usage
Dim instance As PivotCacheDefinition
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class PivotCacheDefinition : OpenXmlLeafElement
Remarks
2.4.18 pivotCacheDefinition
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_PivotCacheDefinition element that specifies the extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache Defintion. See Pivot Table Cache Definition under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.33 CT_PivotCacheDefinition
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: pivotCacheDefinition
A complex type that specifies the extended properties of a PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache Defintion.
Attributes:
slicerData : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies the Slicer Cache Relationship to PivotCache. MUST be TRUE if the OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache Defintion 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 be 0 if there is no slicer cache which uses this PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache as a data source. MUST be greater than or equal to 0.
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 ([ISO/IEC-29500-1] section 18.10) items.
supportSubqueryCalcMem : 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 PivotTable ([ISO/IEC-29500-1] section 18.10) 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<31>.
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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
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.