This topic has not yet been rated - Rate this topic

Members Element (XMLA)

SQL Server 2012

Contains a collection of Member elements contained by the parent CrossProduct element.


<CrossProduct>
   <Members Hierarchy="string">
      <Member>...</Member>
   </Members>
   ...
</CrossProduct>

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	CrossProduct
Child elements	Member

Attributes

Attribute	Description
Hierarchy	Required String attribute. The name of the hierarchy to which the members contained by the Members element belong.

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 Axis element consists of one or more CrossProduct elements. Every CrossProduct element contains a Members element for each hierarchy on the axis. The Members element, in turn, contains one Member element for each member of the specified hierarchy included in the cross-product.

Example

The following example illustrates the structure of the Members 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>

Concepts

Properties (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD