Share via

2.3.2.2.1 Slicer View Relationship to Slicer Cache

  • Article

Each slicer view is associated with a slicer cache. The slicer view is associated with a slicer cache through the name attribute of the CT_SlicerCacheDefinition element in the slicer cache that matches the cache attribute of the CT_Slicer element 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 level attribute of the CT_Slicer element. In this case, the slicer view displays OLAP Slicer Items of that OLAP level.

There can be multiple slicer views associated with a single slicer cache. There are two main reasons for this:

  • For a user-defined OLAP hierarchy with several OLAP levels—for example, a Geography OLAP hierarchy with Country, 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) provide a mechanism for displaying the filter state in more than one location in the workbook.