Share via

2.3.2.1.2 Slicer Cache Relationship to PivotCache

  • Article

A slicer cache can be associated with a PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache. The association is specified by the following rules:

  • If the CT_SlicerCacheDefinition element has a child CT_SlicerCacheData element with a child CT_OlapSlicerCache element, then the type of slicer source data is OLAP and the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache of the slicer cache is specified by the pivotCacheId attribute of the CT_OlapSlicerCache element. The associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache MUST be based on an OLAP connection ([ISO/IEC29500-1:2016] section 18.13.5). The slicerData attribute of the CT_PivotCacheDefinition element MUST be "true".

  • If the CT_SlicerCacheDefinition element has a child CT_SlicerCacheData element with a child CT_TabularSlicerCache element, the type of slicer source data is non-OLAP and the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache of the slicer cache is specified by the pivotCacheId attribute of the CT_TabularSlicerCache element. The associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache MUST be based on a non-OLAP connection ([ISO/IEC29500-1:2016] section 18.13). The slicerData attribute of the CT_PivotCacheDefinition element MUST be "false".

Multiple slicer caches can be associated with one PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache.

If a slicer cache is associated, as specified by Slicer Cache Relationship to PivotTable View, with one or more PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, and the slicer source data type is non-OLAP, the slicer cache and each associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) view MUST be associated with the same PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache and the slicerData attribute of the CT_PivotCacheDefinition element MUST be "false".

If a slicer cache is associated, as specified by Slicer Cache Relationship to PivotTable View, with one or more PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, and the slicer source data type is OLAP, the PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache that is associated with the slicer cache and all PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCaches that are associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST be based on the same OLAP connection ([ISO/IEC29500-1:2016] section 18.13.5) and the PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCaches associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST NOT be associated with any slicer cache. The slicerData attribute of the CT_PivotCacheDefinition element for each PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST be "false".