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. |
Element relationships
Relationship | Element |
---|---|
Parent elements | Axis |
Child elements | Tuple |
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>