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.