Member Object (ADO MD)

      Collections   Properties      

A Member object can represent either a Member of a Level in a CubeDef or a Member of a Position along an Axis in a Cellset. The properties of a Member are slightly different depending on the context in which it is used.

A Member of a CubeDef has a Children collection that contains child members of the current member on the next lower level in the hierarchy. For a Member of a Cellset, the Children collection is always empty.

A Member of a Cellset has two properties, DrilledDown and ParentSameAsPrev, which are useful when displaying the Cellset. An error will occur if these properties are accessed on a member of a CubeDef.

Remarks

With the collections and properties of a Member object in a CubeDef, you can do the following:

• Identify the Member with the Name and UniqueName properties.
  
  
• Return a meaningful string that describes a measure or formula Member with the Description property.
  
  
• Return a string to use when displaying the Member with the Caption property.
  
  
• Obtain related Members in a Hierarchy with the Parent and Children properties.
  
  
• Determine the nature of the Member with the Type property.
  
  
• Obtain information about the Level of the Member with the LevelDepth and LevelName properties.
  
  
• Use the Properties collection to obtain additional information about the Level object.

With the collections and properties of a Member of a Position along an Axis, you can do the following:

• Identify the Member with the Name and UniqueName properties.
  
  
• Return a meaningful string that describes a measure or formula Member with the Description property.
  
  
• Return a string to use when displaying the Member with the Caption property.
  
  
• Determine the nature of the Member with the Type property.
  
  
• Obtain information about the Level of the Member with the LevelDepth and LevelName properties.
  
  
• Use the Properties collection to obtain additional information about the Level object.

The Properties collection contains provider-supplied properties. The following properties should be available, but the actual property list may differ depending upon the implementation of the provider. See the documentation for your provider for a more complete list of available properties.