Share via

2.2.4.5 MDX Metadata

  • Article

The only type of metadata used is MDX metadata.

The MDTInfo record (section 2.4.162) that specifies the metadata type (section 2.2.4.1) for MDX metadata MUST have the following values:

Field

Value

fGhostRow

0

fGhostCol

0

fEdit

0

fDelete

0

fCopy

1

fPasteAll

1

fPasteFormulas

0

fPasteValues

1

fPasteFormats

0

fPasteComments

0

fPasteDataValidation

0

fPasteBorders

0

fPasteColWidths

0

fPasteNumberFormats

0

fMerge

1

fSplitFirst

1

fSplitAll

0

fRowColShift

1

fClearAll

0

fClearFormats

1

fClearContents

0

fClearComments

1

fAssign

1

fCoerce

1

fAdjust

0

fCellMeta

0

stName

"XLMDX"

An MDX metadata record references the connection name and the cube function used or referenced in a cell.

There are four types of MDX metadata records: MDX tuple metadata (section 2.2.4.5.1), MDX set metadata (section 2.2.4.5.2), MDX member property metadata (section 2.2.4.5.3), and MDX KPI metadata (section 2.2.4.5.4).