Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| 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.