Share via

2.3.2.1.6 Slicer Items

  • Article

Slicer items in a slicer cache represent distinct values in a column of the slicer source data. In the case of slicers based on OLAP slicer source data, the slicer cache is based on an OLAP hierarchy and slicer items represent OLAP members within levels of that OLAP hierarchy.

For slicers associated with PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, each slicer item specifies whether slicer source data exists for that slicer item. For more information, see Slicer Cross Filtering.

Each slicer item also specifies the item selection state, used for filtering, and can specify additional properties. For more information see Non-OLAP Slicer Items and OLAP Slicer Items.