This table contains all the levels of all the dimensions of a cube:
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. |
Note that 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.