2.2.14 Slicers

  • Article

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

A slicer has two major parts, a slicer cache (section 2.2.14.1) and a slicer view (section 2.2.14.2). 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.