Export (0) Print
Expand All

MDSCHEMA_LEVELS

SQL Server 2000

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:
  • MDDDIMENSIONS_MEMBER_KEY_UNIQUE

  • MDDIMENSIONS_MEMBER_NAME_UNIQUE
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.

Show:
© 2014 Microsoft