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.