2.1.7.47 Slicer Cache

An instance of the Slicer Cache part type specifies a single slicer cache (section 2.2.14.1) in the workbook<2> (section 2.1.7.61).

Content type: application/vnd.ms-excel.slicerCache

Source relationship: http://schemas.microsoft.com/office/2007/relationships/slicerCache

A package MUST contain one Slicer Cache part per BrtBeginSlicerCacheID (section 2.4.205) record in the workbook (section 2.1.7.61) part, and that part MUST be the target of an explicit relationship from the workbook part.

A Slicer Cache part MUST NOT have implicit or explicit relationships to any part specified in this document.

Record sequence ABNF:

SLICERCACHE = BrtBeginSlicerCache [ACUID] BrtBeginSlicerCacheDef [BrtSlicerCachePivotTables] (SLICERCACHEOLAPIMPL / SLICERCACHENATIVEITEMS) FRTSLICERCACHE BrtEndSlicerCacheDef BrtEndSlicerCache

SLICERCACHEOLAPIMPL = BrtBeginSlicerCacheOlapImpl SLICERCACHELEVELSDATA SLICERCACHESELECTIONS *FRT BrtEndSlicerCacheOlapImpl

SLICERCACHELEVELSDATA = BrtBeginSlicerCacheLevelsData 1*2147483647SLICERCACHELEVELDATA BrtEndSlicerCacheLevelsData

SLICERCACHELEVELDATA = BrtBeginSlicerCacheLevelData SLICERCACHESIRANGES BrtEndSlicerCacheLevelData

SLICERCACHESIRANGES = BrtBeginSlicerCacheSiRanges *2147483647SLICERCACHESIRANGE BrtEndSlicerCacheSiRanges

SLICERCACHESIRANGE = BrtBeginSlicerCacheSiRange 1*1000BrtSlicerCacheOlapItem BrtEndSlicerCacheSiRange

SLICERCACHESELECTIONS = BrtBeginSlicerCacheSelections 1*2147483647BrtSlicerCacheSelection BrtEndSlicerCacheSelections

SLICERCACHENATIVEITEMS = BrtBeginSlicerCacheNative BrtSlicerCacheNativeItem *FRT BrtEndSlicerCacheNative

FRTSLICERCACHE = [SLICERCACHEBOOKPIVOTTABLES] [TABLESLICERCACHE] [SLICERCACHECROSSFILTEREXT] *FRT

SLICERCACHEBOOKPIVOTTABLES = BrtFRTBegin BrtSlicerCacheBookPivotTables BrtFRTEnd

TABLESLICERCACHE = BrtFRTBegin BrtBeginTableSlicerCache *FRT BrtEndTableSlicerCache BrtFRTEnd

SLICERCACHECROSSFILTEREXT = BrtFRTBegin BrtSlicerCacheHideItemsWithNoData BrtFRTEnd

For ABNF rules not listed here, see section 2.1.8.