Compartilhar via


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>

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance