Compartir a través de


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.

See Also

Reference

PivotCacheDefinition Members

DocumentFormat.OpenXml.Office2010.Excel Namespace