Share via

2.2.14.2.1 Slicer View Relationship to Slicer Cache

  • Article

Each slicer view (section 2.2.14.2) is associated with a slicer cache (section 2.2.14.1). The slicer view is associated with a slicer cache through the stName field of the BrtBeginSlicerCacheDef (section 2.4.204) record in the slicer cache that matches the stSlicerCacheName field of the BrtBeginSlicer (section 2.4.202) record that specifies this slicer view.

If a slicer view is associated with an OLAP slicer cache, the slicer view also has an associated OLAP level, specified by the dwLevel field of the BrtBeginSlicer record. In this case the slicer view displays OLAP Slicer Items (section 2.2.14.1.4.2) of that OLAP level.

There can be multiple slicer views associated with a single slicer cache (section 2.2.14.1), for the following two reasons:

  • For a user-defined OLAP hierarchy with several OLAP levels (for example a Geography OLAP hierarchy with Country/Region, State, and City OLAP levels), each slicer view is associated with a single OLAP level, providing a mechanism for filtering different OLAP levels of the OLAP hierarchy.

  • Multiple slicer views associated with either the same slicer cache (for a non-OLAP slicer cache) or the same OLAP level (for an OLAP slicer cache) provides a mechanism for displaying the filter state in more than one location in the workbook.