Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Tuples Element (XMLA)

Contains a set of Tuple objects for an Axis element that uses the MDDataSet data type, returned by the Execute method.


<Axis>
   ...
   <Tuples>
      <Tuple>...</Tuple>
   </Tuples>
   ...
</Axis>

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Relationship

Element

Parent elements

Axis

Child elements

Tuple

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.

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>

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.