This table contains all the members in all the dimensions of the cube:
| 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. Note that this is the rank among all the children of a member. This makes inserts easier. If a new city is inserted into the list of cities for Germany, then there should be no need to update the natural sort rank of all cities in the world.