Tuples Element (XMLA)
Contains a set of Tuple objects for an Axis element that uses the MDDataSet data type, returned by the Execute method.
Syntax
<Axis>
...
<Tuples>
<Tuple>...</Tuple>
</Tuples>
...
</Axis>
Element Characteristics
Characteristic |
Description |
|---|---|
Data type and length |
None |
Default value |
None |
Cardinality |
0-1: Optional element that can occur once and only once. |
Remarks
When a client application sets the AxisFormat property to TupleFormat, an axis is represented as a set of tuples. Each Axis element contains a Tuples element representing the set of tuples on that axis. Each tuple is represented by using a Tuple element that contains Member elements from every hierarchy on the axis.
Example
The following example illustrates the structure of the Tuples element when a client specifies TupleFormat or CustomFormat for the AxisFormat XML for Analysis (XMLA) property, given the following members for the axis:
Time hierarchy |
1999 |
1999 |
2000 |
Category hierarchy |
Actual |
Budget |
Budget |
<Axes>
<Axis name="Axis0">
<Tuples>
<Tuple>
<Member Hierarchy="Time">
<UName>[Time].[1999]</UName>
...
</Member>
<Member Hierarchy="Category">
<UName>[Scenario].[Actual]</UName>
...
</Member>
</Tuple>
<Tuple>
<Member Hierarchy="Time">
<UName>[Time].[1999]</UName>
...
</Member>
<Member Hierarchy="Category">
<UName>[Scenario].[Budget]</UName>
...
</Member>
</Tuple>
<Tuple>
<Member Hierarchy="Time">
<UName>[Time].[2000]</UName>
...
</Member>
<Member Hierarchy="Category">
<UName>[Scenario].[Budget]</UName>
...
</Member>
</Tuple>
</Tuples>
</Axis>
...
</Axes>