Export (0) Print
Expand All
Expand Minimize

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.

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

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Relationship

Element

Parent elements

Axis

Child elements

Members

Attribute

Description

Size

Required 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 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>

Community Additions

ADD
Show:
© 2014 Microsoft