2.3.2.1 Slicer Cache

  • Article

A slicer cache specifies the subset of slicer source data that is cached for display in slicer views, as well as properties related to slicer filtering. A slicer cache is specified by the CT_SlicerCacheDefinition element.

A slicer cache has an associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache as specified in section 2.3.2.1.2, or Table ([ISO/IEC29500-1:2016] section 18.5.1.2).

If the slicer source data is an OLAP data source, the sourceName attribute of the CT_SlicerCacheDefinition element specifies the MDX unique name of the associated OLAP hierarchy.

If the slicer source data is a non-OLAP data source, the sourceName attribute of the CT_SlicerCacheDefinition element specifies the associated PivotTable cache field of the associated PivotTable PivotCache.

If the slicer source data is a table data source, the sourceName attribute of the CT_SlicerCacheDefinition element specifies the associated table field.

If the slicer is used to filter PivotTable views, the slicer cache specifies the PivotTable views being filtered as specified in section 2.3.2.1.4.