2.2.14.1 Slicer Cache

  • Article

A slicer cache specifies the subset of slicer source data (section 2.2.14.1.1) that is cached for display in slicer views (section 2.2.14.2) as well as properties related to slicer (section 2.2.14) filtering. A slicer cache is specified by the sequence of records that conform to the SLICERCACHE rule (defined in section 2.1.7.47).

A slicer cache has an associated PivotCache (section 2.2.5.2) as specified in section 2.2.14.1.2, or Table (section 2.1.7.51).

If the slicer source data is an OLAP data source, the stHierarchy field of the BrtBeginSlicerCacheDef (section 2.4.204) record specifies the MDX unique name of the associated OLAP hierarchy.

If the slicer source data is a non-OLAP data source, the stHierarchy field of the BrtBeginSlicerCacheDef record specifies the associated cache field (section 2.2.5.2.2) of the associated PivotCache.

If the slicer source data is a table data source, the stHierarchy field of the BrtBeginSlicerCacheDef record specifies the associated table column (1).

If the slicer (section 2.2.14) is used to filter PivotTable views (section 2.2.5.3), the slicer cache specifies the PivotTable views being filtered as specified in section 2.2.14.1.3.