MEMBERS Table

OLE DB Programmer's Reference

The MEMBERS table contains all members in all dimensions of the cube. The following table provides a sample selection from the MEMBERS table. It does not include all the columns.

MEMBER_NAME	NATURAL_SORT_RANK
Geography.[All].USA	1
Geography.[All].USA.Kansas	14
Geography.[All] Canada	3
Geography.[All].USA.NewYork.Buffalo	5
Geography.[All].USA.Kansas.Topeka	1
and other rows	-

The MEMBER_NAME and PARENT_NAME values are fully qualified, unambiguous names; that is, they will be fully qualified by the path all the way to the dimension name. The NATURAL_SORT_RANK value is the rank of a member when it is sorted in the natural sort order of the dimension and is the rank among all the children of a member. This makes inserts easier. For example, if a new city is inserted into the list of cities for Germany, there should be no need to update the natural sort rank of all cities in the world.

1998-2001 Microsoft Corporation. All rights reserved.