Share via

2.3.2.1.6.1 Non-OLAP Slicer Items

  • Article

The slicer items of a non–OLAP slicer are specified by an ordered sequence of CT_TabularSlicerCacheItem elements. Each slicer item is associated with a PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache item of the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache field in the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache. For more information, see Slicer Cache Relationship to PivotCache.

The associated cache field is specified by the sourceName attribute of the CT_SlicerCacheDefinition element and MUST be equal to the name attribute of a CT_CacheField ([ISO/IEC29500-4:2016] section A.2) element in the collection of PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache fields ( [ISO/IEC29500-4:2016] section A.2) of the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache. The associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache item is specified by the x attribute of the CT_TabularSlicerCacheItem element, which contains a PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache item index of the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache item in the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache field. Two non–OLAP slicer items MUST NOT be associated with the same PivotTable ([ISO/IEC29500-1:2016] section 18.10) cache item.

The order of non–OLAP slicer items in the slicer cache is specified by the sortOrder, crossFilter, and customListSort attributes of the CT_TabularSlicerCache element.

The CT_TabularSlicerCacheItem element also specifies whether the non–OLAP slicer item is selected for filtering and whether data exists in the slicer source data for it. For more information, see Slicer Cross Filtering.