Tuples Element (XMLA)

 

Applies To: SQL Server 2016 Preview

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>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsAxis
Child elementsTuple

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 hierarchy199919992000
Category hierarchyActualBudgetBudget
<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>  

Properties (XMLA)

Community Additions

ADD
Show: