2.1.7.38 PivotCache Definition

Office

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.165) 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.266) 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:

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] *FRT

FRTPCDFIELD14 = BrtFRTBegin BrtPCDField14 BrtFRTEnd

FRTPCDFIELD15 = BrtFRTBegin ITEMUNIQUENAMES BrtFRTEnd

ITEMUNIQUENAMES = BrtBeginItemUniqueNames 1*BrtItemUniqueName BrtEndItemUniqueNames

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 = [BrtFRTBegin BrtPCDH14 BrtFRTEnd] *FRT

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

DIM = BrtBeginDim BrtEndDim

MGS = BrtBeginMgs *MG BrtEndMGs

MG = BrtBeginMG BrtEndMG

MGMAPS = BrtBeginMGMaps *MAP BrtEndMGMaps

MAP = BrtBeginMap BrtEndMap

FRTPIVOTCACHEDEF = [BrtFRTBegin PCD14 BrtFRTEnd] [PCD15] *FRT

PCD14 = BrtBeginPCD14 BrtEndPCD14

PCDSOURCE14 = [BrtFRTBegin BrtPivotCacheConnectionName BrtFRTEnd] *FRT

PCD15 = BrtFRTBegin BrtPivotCacheIdVersion BrtFRTEnd

PCDH15 = BrtFRTBegin BrtPCDH15 BrtFRTEnd

For ABNF rules not listed here, see section 2.1.8.

Show: