OLE DB Programmer's Reference |
The LEVELS table contains all levels of all dimensions of the 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.
1998-2001 Microsoft Corporation. All rights reserved.