Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| 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.