Metadata Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.sheetMetadata+xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/sheetMetadata

An instance of this part type contains information relating to a cell whose value is related to one or more other cells via OnLine Analytical Processing (OLAP) technology.

A package shall contain no more than one Cell Metadata part, and that part shall be the target of an implicit relationship from the Workbook part (§12.3.23).

example:

<Relationships xmlns="…">
  <Relationship Id="rId10" 
    Type="http://…/sheetMetadata" Target="metadata.xml"/>
</Relationships>

The root element for a part of this content type shall be< metadata>.

example:

<metadata …>
  <metadataTypes count="1">
    <metadataType name="XLMDX" minSupportedVersion="120000" copy="1"
      pasteAll="1" pasteValues="1" merge="1" splitFirst="1" rowColShift="1" 
      clearFormats="1" clearComments="1" assign="1" coerce="1"/>
  </metadataTypes>
  <metadataStrings count="2">
    <s v="externalData"/>
    <s v="[Account].[All Account]"/>
  </metadataStrings>
  <mdxMetadata count="1">
    <m n="0" f="m">
      <t c="1">
        <n v="1"/>
      </t>
    </m>
  </mdxMetadata>
  <valueMetadata count="1">
    <b>
      <r t="1" v="0"/>
    </b>
  </valueMetadata>
</metadata>

The corresponding Connections part contains the following:

<connections …>
  <connection id="1" odcFile="…" keepAlive="1" name="externalData"
    description="…" type="5" refreshedVersion="3" background="1">
    <dbPr connection="Provider=MSOLAP.2;…" command="Budget" commandType="1"/>
    <olapPr sendLocale="1" rowDrillCount="1000" serverFill="1" 
      serverNumberFormat="1" serverFont="1" serverFontColor="1"/>
  </connection>
</connections>

The corresponding Volatile Dependencies part contains the following:

<volTypes …">
  <volType type="cubeFunctions">
    <main first="externalData">
      <tp t="e">
        <v>#N/A</v>
        <stp>1</stp>
        <r r="B3" s="1"/>
      </tp>
    </main>
  </volType>
</volTypes>

The corresponding Pivot Table Cache Definition part contains the following:

<pivotCacheDefinition … saveData="0" refreshedBy="…"
  refreshedDate="2005-11-28T16:55:44" backgroundQuery="1" createdVersion="3"
  refreshedVersion="3" recordCount="0">
  <cacheSource type="external" connectionID="1"/>
  <cacheFields count="0"/>
  <cacheHierarchies count="6">
    …
  </cacheHierarchies>
  <kpis count="0"/>
  <tupleCache>
    <queryCache count="3">
      <query mdx="[product].[category]"/>
      <query mdx=""/>
      <query mdx="[Account].[All Account]">
        <tpls c="1">
          <tpl hier="0" item="4294967295"/>
        </tpls>
      </query>
    </queryCache>
  </tupleCache>
</pivotCacheDefinition>

A Metadata part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

A Metadata part shall not have implicit or explicit relationships to any part defined by this Standard.