Share via

2.3.2 Slicers

  • Article

A slicer is a mechanism for filtering data in PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, cube functions, tables ([ISO/IEC29500-1:2016] section 18.5.1.2) and Charts ([ISO/IEC29500-1:2016] section 21.2) based on Non-Worksheet PivotTables. A slicer is based on a field in the slicer source data, and the slicer filters on distinct values in that column. In the case of using OLAP slicer source data, a slicer is based on an OLAP hierarchy.

A slicer has two major parts, a slicer cache and a slicer view. There can be more than one slicer view based on a single slicer cache. When filtering multi-level OLAP hierarchies using slicers, separate slicer views are used for each OLAP level.