L.2.8.3.2.4 mdxMetadata
This collection expresses MDX metadata, and builds up the MDX members, sets, KPIs, and member properties.
<mdxMetadata count="26">
<mdx n="0" f="m">
<t c="1">
<n x="1"/>
</t>
</mdx>
<mdx n="0" f="m">
<t c="1">
<n x="2"/>
</t>
</mdx>
<mdx n="0" f="m">
<t c="1">
<n x="3"/>"
</t>
</mdx>
<mdx n="0" f="m">
<t c="1">
<n x="4"/>
</t>
</mdx>
<mdx n="0" f="m">
<t c="3">
<n x="1"/>
<n x="2"/>
<n x="4"/>
</t>
</mdx>
<mdx n="0" f="m">
<t c="3">
<n x="1"/>
<n x="3"/>
<n x="4"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="6"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="7"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="8"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="9"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="10"/>
</t>
</mdx>
<mdx n="0" f="r">
<t c="1">
<n x="11"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="6"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="7"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="7"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="8"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="8"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="9"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="9"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="10"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="10"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="11"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="2"/>
<n x="4"/>
<n x="11"/>
</t>
</mdx>
<mdx n="0" f="v">
<t c="4" ct="en-US">
<n x="1"/>
<n x="3"/>
<n x="4"/>
<n x="6"/>
</t>
</mdx>
<mdx n="0" f="s">
<ms ns="5" c="3" o="d">
<n x="1"/>
<n x="3"/>
<n x="4"/>
</ms>
</mdx>
<mdx n="0" f="c">
<ms ns="5" c="3" o="d">
<n x="1"/>
<n x="3"/>
<n x="4"/>
</ms>
</mdx>
</mdxMetadata>Regarding mdxMetadata:
Regarding mdx, which is a particular MDX statement:
Regarding t, which is an MDX tuple:
is the count of member expressions in the MDX tuple.
Regarding n:
For example, cell C5 has a CUBEMEMBER function call expressing the result of “Internet Sales Amount of All Products for CY 2003”. In sheet1.xml, cell C5 has vm=“5”, which means it has an associated valueMetadata record whose index is “5”. Looking ahead into the valueMetadata records, the 5th (1- based) record points to the 4th (zero-based) mdx collection in mdxMetadata.
The 5th mdx collection:
<mdx n="0" f="m">
<t c="3">
<n x="1"/>
<n x="2"/>
<n x="4"/>
</t>
</mdx>Where <n
x="1"/> corresponds to the 1st position in the string store, namely
<s v="[Measures].[Internet Sales Amount]"/>and where <n
x="2"/> corresponds to the 2nd position in the string store, namely
<s v="[Date].[Calendar].[Calendar Year].&[2003]"/>and where <n
x="4"/> corresponds to the 4th position in the string store, namely
<s v="[Product].[Product Categories].[All Products]"/>.Therefore this data point in the cube is addressed by intersecting these three hierarchies, one in each dimension of the OLAP cube:
[Measures].[Internet Sales Amount] [Date].[Calendar].[Calendar Year].[2003] [Product].[Product Categories].[All Products]
Regarding ms:
ns is the index of the MDX set definition in the string store.
c is the number of sort-by member indicies, in this case 3 because the set is sorted by the
contents of D5, which happens to be a member defined by 3 coordinates in the cube.
o indicates the order of the sort; in this case, 'descending'.
n is the index indicating the MDX expressions in the string store used to identify the members
used to define the sort-by set.