2.3.2.1.4 Slicer Cache Relationship to PivotTable View

  • Article

A slicer cache, as specified in section 2.3.2.1, can be associated with PivotTable, as specified in [ISO/IEC29500-1:2016] section 18.10, views and Charts ([ISO/IEC29500-1:2016] section 21.2) based on Non-Worksheet PivotTables, by the pivotTables group element of the CT_SlicerCacheDefinition element, as specified in section 2.6.70.

If the associated PivotTable PivotCache of a slicer cache, as specified by the Slicer Cache Relationship to PivotCache, is an OLAP PivotTable PivotCache, the slicer items, as specified in section 2.3.2.1.6, in the slicer cache are used to apply PivotTable OLAP manual filters to the PivotTable hierarchy specified by the sourceName attribute of the CT_SlicerCacheDefinition element in all associated PivotTable views and Charts based on Non-Worksheet PivotTables, of the slicer cache. The selected slicer items in the slicer cache are converted into selected PivotTable items in the PivotTable OLAP manual filters by the application to apply the filter state of the slicer cache to the associated PivotTable views.

If the associated PivotTable PivotCache of a slicer cache, as specified by Slicer Cache Relationship to PivotCache, is a non-OLAP PivotTable PivotCache, the PivotTable PivotCache of the PivotTable views and the PivotTable PivotCache of the slicer cache MUST be the same.

When an OLAP PivotTable view is associated with an OLAP slicer cache, there MUST NOT be more than one slicer cache for each OLAP hierarchy. If the slicer cache is associated with at least one Chart based on Non-Worksheet PivotTable then the slicer cache MUST be OLAP sourced.

If the associated PivotTable PivotCache of a slicer cache, as specified by Slicer Cache Relationship to PivotCache, is a non-OLAP PivotTable PivotCache, the slicer items in the slicer cache are used to apply PivotTable non-OLAP manual filters to the PivotTable field specified by the sourceName attribute of the CT_SlicerCacheDefinition element in all associated PivotTable views of the slicer cache. The selected slicer items in the slicer cache are converted into selected PivotTable items in the PivotTable non-OLAP manual filters by the application to apply the filter state of the slicer cache to the associated PivotTable views. See the PivotTable items in [ISO/IEC29500-1:2016] section 18.10 for more details.