Members collection (ADO MD)
Applies to: Access 2013, Office 2013
Contains the Member objects from a level or a position along an axis.
Remarks
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: