| title | Members Collection (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 |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | 3a647cde-efdc-4394-b1b9-8cbb1b9d689f | |||
| author | MightyPen | |||
| ms.author | genemi |
Contains the Member objects from a level or a position along an axis.
A Members collection is used to contain the following types of members:
-
The members that make up a level in a cube. These are contained in the Members collection of a Level object. For example, using the sample from Overview of Multidimensional Schemas and Data, the four members of the Countries level are Canada, USA, UK, and Germany.
-
The members that are the children of a specific member within a hierarchy. These members are returned by the Children property of the parent Member object. For example, again using the same sample, the two children of the Canada member are Canada-East and Canada-West.
-
The members that define a specific position along an axis of a cellset. Using the cellset from Working with Multidimensional Data as an example, the two members of the first position on the x-axis are Valentine and Seattle. These members are contained by the Members collection of a Position object.
Members is a standard ADO collection. With the properties and methods of a collection, you can do the following:
-
Obtain the number of objects in the collection with the Count property.
-
Return an object from the collection with the default Item property.
-
Update the objects in the collection from the provider with the Refresh method.
This section contains the following topic.