Share via

2.2.14.1.2 Slicer Cache Relationship to PivotCache

  • Article

A slicer cache (section 2.2.14.1) is associated with a PivotCache (section 2.2.5.2) or Table (section 2.1.7.51). The association is specified by the following rules.

If a slicer cache contains the sequence of records that conforms to the SLICERCACHEOLAPIMPL rule (defined in section 2.1.7.47) then the type of slicer source data (section 2.2.14.1.1) is OLAP and the associated PivotCache (section 2.2.5.2) of the slicer cache is specified by the ipivotcacheid field of the BrtBeginSlicerCacheOlapImpl (section 2.4.210) record of the slicer cache. The associated PivotCache MUST be an OLAP PivotCache as specified in section 2.2.5.2.1. The fSlicerData field of the BrtBeginPCD14 (section 2.4.123) record of the associated PivotCache MUST be 1.

If a slicer cache contains the sequence of records that conforms to the SLICERCACHENATIVEITEMS rule (defined in section 2.1.7.47) then the type of slicer source data (section 2.2.14.1.1) is non-OLAP and the associated PivotCache (section 2.2.5.2) of the slicer cache is specified by the dwcacheId field of the BrtBeginSlicerCacheNative (section 2.4.209) record of the slicer cache. The associated PivotCache MUST NOT be an OLAP PivotCache (section 2.2.5.2) as specified in section 2.2.5.2.1.

If a slicer cache contains the sequence of records that conforms to the TABLESLICERCACHE rule (defined in section 2.1.7.47) then the type of slicer source data (section 2.2.14.1.1) is table and the associated Table (section 2.1.7.51) of the slicer cache is specified by the dwLstd field of the BrtBeginTableSlicerCache (section 2.4.279) record of the slicer cache.

Multiple slicer caches can be associated with one PivotCache.

If a slicer cache is associated (as specified in section 2.2.14.1.3) with one or more PivotTable views (section 2.2.5.3) and the slicer source data (section 2.2.14.1.1) type is non-OLAP then the slicer cache and each associated PivotTable view (section 2.2.5.3), as specified in section 2.2.5.3.1, MUST be associated with the same PivotCache and the fSlicerData field of the BrtBeginPCD14 record of that PivotCache MUST be 0.

If a slicer cache is associated (as specified in section 2.2.14.1.3) with one or more PivotTable views and the slicer source data type is OLAP then the PivotCache that is associated with the slicer cache and all PivotCaches that are associated with the PivotTable views MUST be based on the same OLAP connection (section 2.2.8.3.1) and the PivotCaches associated with the PivotTable views MUST NOT be associated with any slicer cache. The fSlicerData field of the BrtBeginPCD14 record for each PivotCache associated with the PivotTable views MUST be 0.