MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements
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.