2.2.14.1.4.1 Non-OLAP Slicer Items

  • Article

The slicer items of a non–OLAP slicer are specified by an ordered sequence of records that conform to the SLICERCACHENATIVEITEMS rule (as defined in section 2.1.7.47). Each slicer item is associated with a cache item (section 2.2.5.2.3) of the associated cache field (section 2.2.5.2.2) in the associated PivotCache (section 2.2.5.2). Also see section 2.2.14.1.2.

The associated cache field is specified by the stHierarchy field of the BrtBeginSlicerCacheDef (section 2.4.204) record and MUST be equal to the stFldName field of a BrtBeginPCDField (section 2.4.136) record in the collection of cache fields of the associated PivotCache. The associated cache item is specified by the iCache field of the SlicerCacheNativeItem (section 2.5.136) structure. The iCache field of the SlicerCacheNativeItem structure specifies a cache item index of the associated cache item in the associated cache field. Two non–OLAP slicer items MUST NOT be associated with the same cache item.

The order of non–OLAP slicer items in the slicer cache (section 2.2.14.1) is specified by the fSortOrder, fCrossFilter and fSortUsingCustomLists fields of the BrtBeginSlicerCacheNative (section 2.4.209) record.

The SlicerCacheNativeItem structure also specifies whether the non–OLAP slicer item is selected for filtering and if data exists in the slicer source data (section 2.2.14.1.1) for it. Also see section 2.2.14.1.5.