MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements
The LEVELS table contains all levels of all dimensions of a cube. The following table provides a sample selection from the LEVELS table.
| LEVEL_NAME | LEVEL | DIMENSION_NAME |
| Geography.[All] | 0 | Geography |
| Geography.Countries | 1 | Geography |
| Geography.States | 2 | Geography |
| Geography.Cities | 3 | Geography |
| Geography.Zipcode | 4 | Geography |
| Time.[All] | 0 | Time |
| …and so on |
The LEVEL_NAME column contains a level name qualified by the dimension name. For example, the [All] level of the Geography dimension is ambiguous because many dimensions have [All] as the root level. Therefore, the name is Geography.[All], which makes it unambiguous.