Analysis Services Programming
MDSCHEMA_LEVELS
This schema rowset describes each level that is contained within a particular hierarchy.
Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following columns to this schema rowset.
| Column name | Type | Description |
|---|---|---|
| LEVEL_UNIQUE_SETTINGS | DBTYPE_I4 | A bitmap that specifies which columns contain unique values, if the level only has member with unique names or keys. The following bit value constants are defined in Msmd.h for this bitmap:
|
| LEVEL_IS_VISIBLE | DBTYPE_BOOL | Returns TRUE if the dimension is visible. |
| LEVEL_ORDERING_PROPERTY | DBTYPE_WSTR | If the level is sorted by member property, this column returns the name of that property. |
| LEVEL_DBTYPE | DBTYPE_I4 | The DBType enumeration of the member key column that was used to build members for the level. |
| LEVEL_MASTER_UNIQUE_NAME | DBTYPE_WSTR | For levels that are members of a virtual dimension but not (All) levels, specifies the unique name of the level. |
| LEVEL_NAME_SQL_COLUMN_NAME | DBTYPE_WSTR | The name of the column in the SQL query that corresponds to the level's name. |
| LEVEL_KEY_SQL_COLUMN_NAME | DBTYPE_WSTR | The name of the column in the SQL query that corresponds to the level's key. |
| LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME | DBTYPE_WSTR | The name of the column in the SQL query that corresponds to the level's unique name. |
Restriction Columns
CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
LEVEL_NAME
LEVEL_UNIQUE_NAME
For more information about the MDSCHEMA_LEVELS schema rowset, see the OLE DB documentation.