Export (0) Print
Expand All
Expand Minimize

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 PivotCacheDefinition part per BrtBeginPivotCacheID (section 2.4.163) record in the workbook (section 2.1.7.60) 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.264) 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 PivotCacheDefinition part is permitted to have an explicit relationship to the following part specified in this document:

A PivotCacheDefinition part MUST NOT have any implicit or explicit relationships to any other parts specified by this document.

Record sequence ABNF:

PIVOTCACHEDEF = BrtBeginPivotCacheDef PCDSOURCE PCDFIELDS [PCDCALCITEMS] [PCDHIERARCHIES] [PCDKPIS] [PCDCALCMEMS] [PCDSDTUPLECACHE] [DIMS] [MGS [MGMAPS]] FRTPIVOTCACHEDEF BrtEndPivotCacheDef

PCDSOURCE = BrtBeginPCDSource [PCDSRANGE / PCDSCONSOL] PCDSOURCE14 BrtEndPCDSource

PCDSRANGE = BrtBeginPCDSRangeBrtEndPCDSRange

PCDSCONSOL = BrtBeginPCDSConsol [PCDSCPAGES] PCDSCSETS BrtEndPCDSConsol

PCDSCPAGES = BrtBeginPCDSCPages *4PCDSCPAGE BrtEndPCDSCPages

PCDSCPAGE = BrtBeginPCDSCPage *PCDSCPITEM BrtEndPCDSCPage

PCDSCPITEM = BrtBeginPCDSCPItemBrtEndPCDSCPItem

PCDSCSETS = BrtBeginPCDSCSets 1*PCDSCSET BrtEndPCDSCSets

PCDSCSET = BrtBeginPCDSCSetBrtEndPCDSCSet

PCDFIELDS = BrtBeginPCDFields *PCDFIELD BrtEndPCDFields

PCDFIELD = BrtBeginPCDField [PNAMES] [PCDFATBL] [PCDFGROUP] FRTPCDFIELD BrtEndPCDField

FRTPCDFIELD = [FRTPCDFIELD14] [FRTPCDFIELD15] *FRT

FRTPCDFIELD14 = BrtFRTBeginBrtPCDField14BrtFRTEnd

FRTPCDFIELD15 = BrtFRTBegin ITEMUNIQUENAMES BrtFRTEnd

ITEMUNIQUENAMES = BrtBeginItemUniqueNames 1*BrtItemUniqueNameBrtEndItemUniqueNames

PNAMES = BrtBeginPNames *PNAME BrtEndPNames

PNAME = BrtBeginPName [PNPAIRS] BrtEndPName

PNPAIRS = BrtBeginPNPairs PNPAIR BrtEndPNPairs

PNPAIR = BrtBeginPNPairBrtEndPNPair

PCDFATBL = BrtBeginPCDFAtbl *(PCDI / PCDIA) BrtEndPCDFAtbl

PCDI = BrtPCDIMissing / BrtPCDINumber / BrtPCDIBoolean / BrtPCDIError / BrtPCDIString / BrtPCDIDatetime / PCDIRUN

PCDIA = BrtPCDIAMissing / BrtPCDIANumber / BrtPCDIABoolean / BrtPCDIAError / BrtPCDIAString / BrtPCDIADatetime

PCDIRUN = BrtBeginPCDIRunBrtEndPCDIRun

PCDFGROUP = BrtBeginPCDFGroup [PCDFGRANGE / PCDFGDISCRETE] [PCDFGITEMS] BrtEndPCDFGroup

PCDFGRANGE = BrtBeginPCDFGRangeBrtEndPCDFGRange

PCDFGDISCRETE = BrtBeginPCDFGDiscrete 1*BrtPCDIIndexBrtEndPCDFGDiscrete

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 = BrtBeginPCDHFieldsUsageBrtEndPCDHFieldsUsage

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 = BrtBeginPCDHGLGMemberBrtEndPCDHGLGMember

FRTPCDHIERARCHY = [BrtFRTBegin BrtPCDH14 BrtFRTEnd] *FRT

PCDKPIS = BrtBeginPCDKPIs *PCDKPI BrtEndPCDKPIs

PCDKPI = BrtBeginPCDKPIBrtEndPCDKPI

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 = BrtBeginPCDSDTCEMemberBrtEndPCDSDTCEMember

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*BrtPCDSFCIEntryBrtEndPCDSFCIEntries

DIMS = BrtBeginDims 1*DIM BrtEndDims

DIM = BrtBeginDimBrtEndDim

MGS = BrtBeginMgs *MG BrtEndMGs

MG = BrtBeginMGBrtEndMG

MGMAPS = BrtBeginMGMaps *MAP BrtEndMGMaps

MAP = BrtBeginMapBrtEndMap

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

PCD14 = BrtBeginPCD14BrtEndPCD14

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:
© 2015 Microsoft