Share via

2.6.33 CT_PivotCacheDefinition

  • Article

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/IEC29500-1:2016] section 18.10) PivotCache definition.

Attributes:

slicerData: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the Slicer Cache Relationship to PivotCache. MUST be "true" if the OLAP PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache definition is being referenced by a slicer cache.

pivotCacheId: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute which uniquely identifies this PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache. The value MUST be greater than or equal to 0. The value MUST NOT be 0 if there is a slicer cache that uses this PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache as a data source, or if there is a CT_PivotCacheIdVersion element that is preceded by this element.

supportSubqueryNonVisual: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable ([ISO/IEC29500-1:2016] section 18.10) supports hidden PivotTable items.

supportSubqueryCalcMem: A Boolean ([XMLSCHEMA2/2] 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.

Value

Meaning

"true"

The OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.

"false"

The OLAP source data of this PivotTable does not support PivotTable calculated members in an OLAP subselect for filtering.

supportAddCalcMems: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC29500-1:2016] section 18.10) calculated members are shown for filtering.

The following W3C XML Schema ([XMLSCHEMA1/2] 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/2] section 2.1).