2.3.2.1.7 Slicer Cross Filtering

  • Article

Cross filtering is an application behavior that allows one slicer to reflect the results of filtering by another. This behavior exposes whether data exists in the slicer source data for each slicer item when the slicer source data is filtered by the selected slicer items of all associated slicer caches of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) view, as specified by Slicer Cache Relationship to PivotTable View, and all PivotTable ([ISO/IEC29500-1:2016] section 18.10) manual filters in the PivotTable ([ISO/IEC29500-1:2016] section 18.10) view.

If the type of slicer source data is OLAP, the existence of data, after filtering, for a slicer item is specified by the nd attribute of the CT_OlapSlicerCacheItem element. If the type of slicer source data is non-OLAP, the existence of data for a slicer item is specified by the nd attribute of the CT_TabularSlicerCacheItem element.

If the type of slicer source data is non-OLAP, the crossFilter attribute of the CT_TabularSlicerCache element specifies how the non-OLAP slicer items that have no data appear.

If the type of slicer source data is OLAP, the crossFilter attribute of the CT_OlapSlicerCacheLevelData element specifies how the OLAP slicer items that have no data are displayed for the OLAP level specified by the uniqueName attribute of the CT_OlapSlicerCacheLevelData element.