LEVELS Table

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.