Share via

2.2.4.8 MDX Metadata

  • Article

MDX is the only defined metadata type. MDX metadata is used to maintain cached state for cube functions.

The metadata type (section 2.2.4.1) of MDX metadata MUST have the following properties:

  • The grbit field of the BrtMdtinfo (section 2.4.704) record MUST have the following values:

MdtFlags properties

Value

fGhostRw

0

fGhostCol

0

fEdit

0

fDelete

0

fCopy

1

fPasteAll

1

fPasteFmlas

0

fPasteValues

1

fPasteFmts

0

fPasteComments

0

fPasteDv

0

fPasteBorders

0

fPasteColWidths

0

fPasteNumFmts

0

fMerge

1

fSplitFirst

1

fSplitAll

0

fRwColShift

1

fClearAll

0

fClearFmts

1

fClearContents

0

fClearComments

1

fAssign

1

fCanCoerce

1

fAdjust

0

fCellMeta

0

  • The metadataID field of the BrtMdtinfo (section 2.4.704) record MUST be 120000.

  • The stName field of the BrtMdtinfo record MUST be "XLMDX".

MDX metadata records are stored in the MDX metadata store (section 2.2.4.4). An MDX metadata record references the connection name and the cube function used to calculate the cell value.

An MDX metadata record also contains one additional record that further describes the MDX metadata record. That additional record depends on the type of cube function used, and MUST be an MDX tuple metadata (section 2.2.4.8.1) record, an MDX set metadata (section 2.2.4.8.2) record, an MDX member property metadata (section 2.2.4.8.3) record, or an MDX KPI metadata (section 2.2.4.8.4) record.

An MDX metadata record is specified by a BrtBeginMdx (section 2.4.106) record and ends with a BrtEndMdx (section 2.4.457) record. All MDX metadata records are stored in the MDX metadata store (section 2.2.4.4) specified by the BrtBeginEsmdx (section 2.4.76) record and ends with a BrtEndEsmdx (section 2.4.427) record.