CrossProduct Element
TOC
Collapse the table of content
Expand the table of content

CrossProduct Element (XMLA)

 

Applies To: SQL Server 2016 Preview

Contains a cross-product between ordered sets of members from each hierarchy for an Axis element that uses the MDDataSet data type, returned by the Execute method.

  
<Axis>  
   ...  
   <CrossProduct Size="integer">  
      <Members>...</Members>  
   </CrossProduct>  
   ...  
</Axis>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsAxis
Child elementsMembers
AttributeDescription
SizeRequired Integer attribute. Indicates the number of tuples contained in the cross-product represented by the CrossProduct element.

When a client application sets the AxisFormat property to ClusterFormat, the members on each axis are divided into clusters in which each cluster represents a cross-product between ordered sets of members from each hierarchy. Each cluster is represented by a CrossProduct element. Every CrossProduct element contains a Members element for each hierarchy on the axis. A CrossProduct element can contain members from a single hierarchy.

The following example illustrates the structure of the CrossProduct element when a client specifies ClusterFormat for the AxisFormat XMLA property, given the following members for the axis:

Time hierarchy1999199920002001
Category hierarchyActualBudgetBudgetBudget
ClustersCluster 1Cluster 1Cluster 1Cluster 2
<Axes>  
   <Axis name="Axis0">  
      <CrossProduct Size="4">  
         <Members Hierarchy="Time">  
            <Member>  
               <UName>[Time].[1999]</UName>  
               ...  
            </Member>  
            <Member>  
               <UName>[Time].[2000]</UName>  
               ...  
            </Member>  
         </Members>  
         <Members Hierarchy="Category">  
            <Member>  
               <UName>[Scenario].[Actual]</UName>  
               ...  
            </Member>  
            <Member>  
               <UName>[Scenario].[Budget]</UName>  
               ...  
            </Member>  
         </Members>  
      </CrossProduct>  
      <CrossProduct Size="1">  
         <Members Hierarchy="Time">  
            <Member>  
               <UName>[Time].[2001]</UName>  
               ...  
            </Member>  
         </Members>  
         <Members Hierarchy="Category">  
            <Member>  
               <UName>[Scenario].[Budget]</UName>  
               ...  
            </Member>  
         </Members>  
      </CrossProduct>  
   </Axis>  
   ...  
</Axes>  

Properties (XMLA)

Community Additions

ADD
Show:
© 2016 Microsoft