2.2.14.1.3 Slicer Cache Relationship to PivotTable View

  • Article

A slicer cache (section 2.2.14.1) can be associated with PivotTable views (section 2.2.5.3) and Charts ([ISO/IEC29500-1:2016] section 21.2) based on Non-Worksheet PivotTables. Associated PivotTable views are specified by the BrtSlicerCachePivotTables (section 2.4.791) record of the slicer cache.

If the associated PivotCache (section 2.2.5.2) of a slicer cache (as specified in section 2.2.14.1.2) is an OLAP PivotCache, then the slicer items (section 2.2.14.1.4) in the slicer cache are used to apply OLAP manual filters (section 2.2.5.3.5.2) to the pivot hierarchy (section 2.2.5.3.4) specified by the stHierarchy field of the BrtBeginSlicerCacheDef (section 2.4.204) record in all associated PivotTable views (section 2.2.5.3) and Charts based on Non-Worksheet PivotTables of the slicer cache. The selected slicer items (section 2.2.14.1.4) in the slicer cache are converted into OLAP manual filters by the application to apply the filter state of the slicer cache to the associated PivotTable views.

If the associated PivotCache of a slicer cache (as specified in section 2.2.14.1.2) is a non-OLAP PivotCache, then the PivotCache of the PivotTable views and the PivotCache of the slicer cache MUST be the same. 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 PivotCache of a slicer cache (as specified in section 2.2.14.1.2) is a non-OLAP PivotCache, then the slicer items (section 2.2.14.1.4) in the slicer cache are used to apply non-OLAP manual filters (section 2.2.5.3.5.1) to the pivot field (section 2.2.5.3.2) specified by the stHierarchy field of the BrtBeginSlicerCacheDef record in all associated PivotTable views (section 2.2.5.3) of the slicer cache. The selected slicer items in the slicer cache are converted into selected pivot items (section 2.2.5.3.3) in the non-OLAP manual filters by the application to apply the filter state of the slicer cache to the associated PivotTable views.

When an OLAP PivotTable views is associated with a slicer cache, there MUST NOT be more than one slicer cache for each OLAP hierarchy.

A slicer cache (section 2.2.14.1) can be associated with a column (1) in a Table (section 2.1.7.51). Associated column (1) is specified by the dwColumn field of the BrtBeginTableSlicerCache (section 2.4.279) record of the slicer cache.