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

Members Element (XMLA)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsCrossProduct
Child elementsMember
AttributeDescription
HierarchyRequired String attribute. The name of the hierarchy to which the members contained by the Members element belong.

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.

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