2.2.14.1.5 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 (section 2.2.14.1.1) for each slicer item (section 2.2.14.1.4) when the slicer source data is filtered by the selected slicer items of all associated slicer caches (section 2.2.14.1) of a PivotTable view (section 2.2.5.3), as specified in section 2.2.14.1.3, and all manual filters (section 2.2.5.3.5) in the PivotTable view.

If the type of slicer source data is OLAP then the existence of data, after filtering, for a slicer item is specified by the fNoData field of the BrtSlicerCacheOlapItem (section 2.4.790) record. If the type of source data (section 2.2.5.2.1) is non-OLAP then the existence of data for a slicer item is specified by the fNoData field of the SlicerCacheNativeItem (section 2.5.136) structure contained in the BrtSlicerCacheNativeItem (section 2.4.789) record.

If the type of slicer source data (section 2.2.14.1.1) is non-OLAP, the fCrossFilter field of the BrtBeginSlicerCacheNative record as specified by the Slicer Cache (section 2.1.7.47) part ABNF specifies how the non-OLAP slicer items (section 2.2.14.1.4.1) that have no data are displayed.

If the type of slicer source data is OLAP, the fCrossFilter field of the BrtBeginSlicerCacheLevelData (section 2.4.207) record as specified by the Slicer Cache (section 2.1.7.47) part ABNF specifies how the OLAP slicer items (section 2.2.14.1.4.2) that have no data are displayed for the OLAP level specified by the stUniqueName field of the BrtBeginSlicerCacheLevelData record.