CrossProduct Element (XMLA)

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.

Syntax

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

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Axis
Child elements	Members

Attributes

Attribute	Description
Size	Required Integer attribute. Indicates the number of tuples contained in the cross-product represented by the CrossProduct element.

Remarks

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.

Example

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 hierarchy	1999	1999	2000	2001
Category hierarchy	Actual	Budget	Budget	Budget
Clusters	Cluster 1	Cluster 1	Cluster 1	Cluster 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>

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance