2.1.7.38 PivotCache Definition
An instance of the PivotCache Definition part type specifies a PivotCache (section 2.2.5.2) for one or more PivotTables (section 2.2.5) or cube functions.
Content type: application/vnd.ms-excel.pivotCacheDefinition
Source relationship: http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition
A package MUST contain one PivotCache Definition part per BrtBeginPivotCacheID (section 2.4.169) record in the workbook (section 2.1.7.61) part, and each such part MUST be the target of an explicit relationship from a workbook part. In addition, if the idCache field of the BrtBeginSXView (section 2.4.275) record in a PivotTable (section 2.1.7.40) part is equal to the idSx field of any BrtBeginPivotCacheID record in the workbook part, then the PivotCache Definition part corresponding to that BrtBeginPivotCacheID record MUST be the target of an implicit relationship from that PivotTable (section 2.1.7.40) part.
A PivotCache Definition part is permitted to have an explicit relationship to the following part specified in this document:
PivotCache Records (section 2.1.7.39)
A PivotCache Definition part MUST NOT have any implicit or explicit relationships to any other parts specified by this document.
Record sequence ABNF:
PIVOTCACHEDEF = [ACUID] BrtBeginPivotCacheDef PCDSOURCE PCDFIELDS [PCDCALCITEMS] [PCDHIERARCHIES] [PCDKPIS] [PCDCALCMEMS] [PCDSDTUPLECACHE] [DIMS] [MGS [MGMAPS]] FRTPIVOTCACHEDEF BrtEndPivotCacheDef
PCDSOURCE = BrtBeginPCDSource [PCDSRANGE / PCDSCONSOL] PCDSOURCE14 BrtEndPCDSource
PCDSRANGE = BrtBeginPCDSRange BrtEndPCDSRange
PCDSCONSOL = BrtBeginPCDSConsol [PCDSCPAGES] PCDSCSETS BrtEndPCDSConsol
PCDSCPAGES = BrtBeginPCDSCPages *4PCDSCPAGE BrtEndPCDSCPages
PCDSCPAGE = BrtBeginPCDSCPage *PCDSCPITEM BrtEndPCDSCPage
PCDSCPITEM = BrtBeginPCDSCPItem BrtEndPCDSCPItem
PCDSCSETS = BrtBeginPCDSCSets 1*PCDSCSET BrtEndPCDSCSets
PCDSCSET = BrtBeginPCDSCSet BrtEndPCDSCSet
PCDFIELDS = BrtBeginPCDFields *PCDFIELD BrtEndPCDFields
PCDFIELD = BrtBeginPCDField [PNAMES] [PCDFATBL] [PCDFGROUP] FRTPCDFIELD BrtEndPCDField
FRTPCDFIELD = [FRTPCDFIELD14] [FRTPCDFIELD15] [FRTPCDFIELDIGNORABLE] *FRT
FRTPCDFIELD14 = BrtFRTBegin BrtPCDField14 BrtFRTEnd
FRTPCDFIELD15 = BrtFRTBegin ITEMUNIQUENAMES BrtFRTEnd
ITEMUNIQUENAMES = BrtBeginItemUniqueNames 1*BrtItemUniqueName BrtEndItemUniqueNames
FRTPCDFIELDIGNORABLE = BrtFRTBegin BrtPivotFieldIgnorableAfter BrtFRTEnd
PNAMES = BrtBeginPNames *PNAME BrtEndPNames
PNAME = BrtBeginPName [PNPAIRS] BrtEndPName
PNPAIRS = BrtBeginPNPairs PNPAIR BrtEndPNPairs
PNPAIR = BrtBeginPNPair BrtEndPNPair
PCDFATBL = BrtBeginPCDFAtbl *(PCDI / PCDIA) BrtEndPCDFAtbl
PCDI = BrtPCDIMissing / BrtPCDINumber / BrtPCDIBoolean / BrtPCDIError / BrtPCDIString / BrtPCDIDatetime / PCDIRUN
PCDIA = BrtPCDIAMissing / BrtPCDIANumber / BrtPCDIABoolean / BrtPCDIAError / BrtPCDIAString / BrtPCDIADatetime
PCDIRUN = BrtBeginPCDIRun BrtEndPCDIRun
PCDFGROUP = BrtBeginPCDFGroup [PCDFGRANGE / PCDFGDISCRETE] [PCDFGITEMS] BrtEndPCDFGroup
PCDFGRANGE = BrtBeginPCDFGRange BrtEndPCDFGRange
PCDFGDISCRETE = BrtBeginPCDFGDiscrete 1*BrtPCDIIndex BrtEndPCDFGDiscrete
PCDFGITEMS = BrtBeginPCDFGItems *PCDI BrtEndPCDFGItems
PCDCALCITEMS = BrtBeginPCDCalcItems 1*PCDCALCITEM BrtEndPCDCalcItems
PCDCALCITEM = BrtBeginPCDCalcItem PIVOTRULE [PNAMES] *FRT BrtEndPCDCalcItem
PCDHIERARCHIES = BrtBeginPCDHierarchies 1*PCDHIERARCHY BrtEndPCDHierarchies
PCDHIERARCHY = BrtBeginPCDHierarchy [PCDHFIELDSUSAGE] [PCDHGLEVELS] FRTPCDHIERARCHY BrtEndPCDHierarchy
PCDHFIELDSUSAGE = BrtBeginPCDHFieldsUsage BrtEndPCDHFieldsUsage
PCDHGLEVELS = BrtBeginPCDHGLevels 1*PCDHGLEVEL BrtEndPCDHGLevels
PCDHGLEVEL = BrtBeginPCDHGLevel [PCDHGLGROUPS] *FRT BrtEndPCDHGLevel
PCDHGLGROUPS = BrtBeginPCDHGLGroups 1*PCDHGLGROUP BrtEndPCDHGLGroups
PCDHGLGROUP = BrtBeginPCDHGLGroup PCDHGLGMEMBERS BrtEndPCDHGLGroup
PCDHGLGMEMBERS = BrtBeginPCDHGLGMembers 1*PCDHGLGMEMBER BrtEndPCDHGLGMembers
PCDHGLGMEMBER = BrtBeginPCDHGLGMember BrtEndPCDHGLGMember
FRTPCDHIERARCHY = [FRTPCDH14] [FRTPCDHIGNORABLE] *FRT
FRTPCDH14 = BrtFRTBegin BrtPCDH14 BrtFRTEnd
FRTPCDHIGNORABLE = BrtFRTBegin BrtPivotHierarchyIgnorableAfter BrtFRTEnd
PCDKPIS = BrtBeginPCDKPIs *PCDKPI BrtEndPCDKPIs
PCDKPI = BrtBeginPCDKPI BrtEndPCDKPI
PCDCALCMEMS = BrtBeginPCDCalcMems 1*PCDCALCMEM BrtEndPCDCalcMems
PCDCALCMEM = BrtBeginPCDCalcMem FRTPCDCALCMEM BrtEndPCDCalcMem
FRTPCDCALCMEM = [BrtFRTBegin PCDCALCMEM14 BrtFRTEnd] *FRT
PCDSDTUPLECACHE = BrtBeginPCDSDTupleCache [PCDSDTCENTRIES] [PCDSDTCSETS] [PCDSDTCQUERIES] [PCDSFCIENTRIES] *FRT BrtEndPCDSDTupleCache
PCDSDTCENTRIES = BrtBeginPCDSDTCEntries *PCDSDTCENTRY BrtEndPCDSDTCEntries
PCDSDTCENTRY = (BrtPCDIMissing / BrtPCDINumber / BrtPCDIError / BrtPCDIString) [PCDSDTCEMEMBERS]
PCDSDTCEMEMBERS = BrtBeginPCDSDTCEMembers 1*PCDSDTCEMEMBER BrtEndPCDSDTCEMembers
PCDSDTCEMEMBER = BrtBeginPCDSDTCEMember BrtEndPCDSDTCEMember
PCDSDTCSETS = BrtBeginPCDSDTCSets 1*PCDSDTCSET BrtEndPCDSDTCSets
PCDSDTCSET = BrtBeginPCDSDTCSet *PCDSDTCEMEMBERS [PCDSDTCEMEMBERSSORTBY] BrtEndPCDSDTCSet
PCDSDTCEMEMBERSSORTBY = BrtBeginPCDSDTCEMembersSortBy 1*PCDSDTCEMEMBER BrtEndPCDSDTCEMembers
PCDSDTCQUERIES = BrtBeginPCDSDTCQueries 1*PCDSDTCQUERY BrtEndPCDSDTCQueries
PCDSDTCQUERY = BrtBeginPCDSDTCQuery [PCDSDTCEMEMBERS] BrtEndPCDSDTCQuery
PCDSFCIENTRIES = BrtBeginPcdSFCIEntries 1*BrtPCDSFCIEntry BrtEndPCDSFCIEntries
DIMS = BrtBeginDims 1*DIM BrtEndDims
MGS = BrtBeginMgs *MG BrtEndMGs
MGMAPS = BrtBeginMGMaps *MAP BrtEndMGMaps
PCD14 = BrtBeginPCD14 BrtEndPCD14
PCDSOURCE14 = [BrtFRTBegin BrtPivotCacheConnectionName BrtFRTEnd] *FRT
PCD15 = BrtFRTBegin BrtPivotCacheIdVersion BrtFRTEnd
PCDH15 = BrtFRTBegin BrtPCDH15 BrtFRTEnd
PIVOTCACHEVERSIONINGINFO = BrtFRTBegin BrtBeginCacheVersionInfo 1*(BrtPivotRequiredFeature / BrtPivotLastUsedFeature) BrtEndCacheVersionInfo BrtFRTEnd
PIVOTCACHERICHDATA = BrtFRTBegin BrtPivotCacheRichData BrtFRTEnd
PIVOTCACHEIMPLICITMEASURESUPPORT = BrtFRTBegin BrtPivotCacheImplicitMeasureSupport BrtFRTEnd
For ABNF rules not listed here, see section 2.1.8.