--- title: "Member Object (ADO MD) | Microsoft Docs" ms.prod: sql ms.prod_service: connectivity ms.technology: connectivity ms.custom: "" ms.date: "01/19/2017" ms.reviewer: "" ms.topic: conceptual apitype: "COM" f1_keywords: - "Member" helpviewer_keywords: - "Member object [ADO MD], members" ms.assetid: 3dedf755-0741-4c3f-8b4e-bff8ff8809c8 author: MightyPen ms.author: genemi --- # Member Object (ADO MD) Represents a member of a level in a cube, the children of a member of a level, or a member of a position along an axis of a cellset. ## Remarks The properties of a **Member** differ depending on the context in which it is used. A **Member** of a [Level](../../../ado/reference/ado-md-api/level-object-ado-md.md) in a [CubeDef](../../../ado/reference/ado-md-api/cubedef-object-ado-md.md) has a [Children](../../../ado/reference/ado-md-api/children-property-ado-md.md) property that returns the **Members** on the next lower level in the hierarchy from the current **Member**. For a **Member** of a [Position](../../../ado/reference/ado-md-api/position-object-ado-md.md), the **Children** collection is always empty. Also, the [Type](../../../ado/reference/ado-md-api/type-property-ado-md.md) property applies only to **Members** of a **Level**. A **Member** of **Position** has two properties that are useful when displaying the [Cellset](../../../ado/reference/ado-md-api/cellset-object-ado-md.md): [DrilledDown](../../../ado/reference/ado-md-api/drilleddown-property-ado-md.md) and [ParentSameAsPrev](../../../ado/reference/ado-md-api/parentsameasprev-property-ado-md.md). An error will occur if these properties are accessed on a **Member** of a **Level**. With the collections and properties of a **Member** object of a **Level**, you can do the following: - Identify the **Member** with the [Name](../../../ado/reference/ado-md-api/name-property-ado-md.md) and [UniqueName](../../../ado/reference/ado-md-api/uniquename-property-ado-md.md) properties. - Return a string to use when displaying the **Member** with the [Caption](../../../ado/reference/ado-md-api/caption-property-ado-md.md) property. - Return a meaningful string that describes a measure or formula **Member** with the [Description](../../../ado/reference/ado-md-api/description-property-ado-md.md) property. - Determine the nature of the **Member** with the [Type](../../../ado/reference/ado-md-api/type-property-ado-md.md) property. - Obtain information about the **Level** of the **Member** with the [LevelDepth](../../../ado/reference/ado-md-api/leveldepth-property-ado-md.md) and [LevelName](../../../ado/reference/ado-md-api/levelname-property-ado-md.md) properties. - Obtain related **Members** in a [Hierarchy](../../../ado/reference/ado-md-api/hierarchy-object-ado-md.md) with the [Parent](../../../ado/reference/ado-md-api/parent-property-ado-md.md) and [Children](../../../ado/reference/ado-md-api/children-property-ado-md.md) properties. - Count the children of a **Member** with the [ChildCount](../../../ado/reference/ado-md-api/childcount-property-ado-md.md) property. - Use the standard ADO [Properties](../../../ado/reference/ado-api/properties-collection-ado.md) collection to obtain additional information about the **Level** object. With the collections and properties of a **Member** of a **Position** along an [Axis](../../../ado/reference/ado-md-api/axis-object-ado-md.md), you can do the following: - Identify the **Member** with the [Name](../../../ado/reference/ado-md-api/name-property-ado-md.md) and [UniqueName](../../../ado/reference/ado-md-api/uniquename-property-ado-md.md) properties. - Return a string to use when displaying the **Member** with the [Caption](../../../ado/reference/ado-md-api/caption-property-ado-md.md) property. - Return a meaningful string that describes a measure or formula **Member** with the [Description](../../../ado/reference/ado-md-api/description-property-ado-md.md) property. - Obtain information about the **Level** of the **Member** with the [LevelDepth](../../../ado/reference/ado-md-api/leveldepth-property-ado-md.md) and [LevelName](../../../ado/reference/ado-md-api/levelname-property-ado-md.md) properties. - Count the children of a **Member** with the [ChildCount](../../../ado/reference/ado-md-api/childcount-property-ado-md.md) property. - Use the [DrilledDown](../../../ado/reference/ado-md-api/drilleddown-property-ado-md.md) property to determine whether there is at least one child on the **Axis** immediately following this **Member**. - Use the [ParentSameAsPrev](../../../ado/reference/ado-md-api/parentsameasprev-property-ado-md.md) property to determine whether the parent of this **Member** is the same as the parent of the immediately preceding **Member**. - Use the standard ADO [Properties](../../../ado/reference/ado-api/properties-collection-ado.md) collection to obtain additional information about the **Level** object. The **Properties** collection contains provider-supplied properties. The following table lists properties that might be available. 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. |Name|Description| |----------|-----------------| |CatalogName|The name of the catalog to which this cube belongs.| |ChildrenCardinality|The number of children that the member has.| |CubeName|The name of the cube.| |Description|A meaningful description of the member.| |DimensionUniqueName|The unambiguous name of the [dimension](../../../ado/reference/ado-md-api/dimension-object-ado-md.md).| |HierarchyUniqueName|The unambiguous name of the hierarchy.| |LevelNumber|The distance between the level and the root of the hierarchy.| |LevelUniqueName|The unambiguous name of the level.| |MemberCaption|A label or caption associated with the member.| |MemberGUID|The GUID of the member.| |MemberName|The name of the member.| |MemberOrdinal|The ordinal number of the member.| |MemberType|The type of the member.| |MemberUniqueName|The unambiguous name of the member.| |ParentCount|The count of the number of parents that this member has.| |ParentLevel|The level number of the member's parent.| |ParentUniqueName|The unambiguous name of the member's parent.| |SchemaName|The name of the schema to which this cube belongs.| This section contains the following topic. - [Properties, Methods, and Events](../../../ado/reference/ado-md-api/member-object-properties-methods-and-events.md) ## See Also [Catalog Example (VB)](../../../ado/reference/ado-md-api/catalog-example-vb.md) [Members Collection (ADO MD)](../../../ado/reference/ado-md-api/members-collection-ado-md.md) [Properties Collection (ADO)](../../../ado/reference/ado-api/properties-collection-ado.md)