Resources

LEVELS Schema Rowset

The LEVELS schema rowset returns metadata about the levels that are available on the dimensions that can be accessed by the provider. Each row in the LEVELS schema rowset corresponds to one level that is available in the provider.

The following table describes the columns that are available in the LEVELS schema rowset.

Column Name Type Indicator Mapped Value Restrictions
Supported?
CATALOG_NAME DBTYPE_WSTR Name of the catalog that contains this level. Yes
SCHEMA_NAME DBTYPE_WSTR Name of the schema that contains this level. Yes
CUBE_NAME DBTYPE_WSTR Name of the cube that contains this level. Yes
DIMENSION_UNIQUE_NAME DBTYPE_WSTR Unique name of the dimension that contains this level. Yes
HIERARCHY_UNIQUE_NAME DBTYPE_WSTR Unique name of the hierarchy that contains this level. Yes
LEVEL_NAME DBTYPE_WSTR Name of this level. Yes
LEVEL_UNIQUE_NAME DBTYPE_WSTR Unique name of this level. Yes
LEVEL_GUID DBTYPE_GUID GUID of this level. No
LEVEL_CAPTION DBTYPE_WSTR Caption of this level. Same as LEVEL_NAME if this level has no caption. No
LEVEL_NUMBER DBTYPE_UI4 The distance from this level to the root of the hierarchy. The LEVEL_NUMBER of the root level is 0. No
LEVEL_CARDINALITY DBTYPE_UI4 The number of members contained by this level. No
LEVEL_TYPE DBTYPE_I4 The type of this level, either:
  • MDLEVEL_TYPE_REGULAR
  • MDLEVEL_TYPE_ALL
  • MDLEVEL_TYPE_CALCULATED
  • MDLEVEL_TYPE_TIME
  • MDLEVEL_TYPE_TIME_YEARS
  • MDLEVEL_TYPE_TIME_HALF_YEARS
  • MDLEVEL_TYPE_QUARTERS
  • MDLEVEL_TYPE_MONTHS
  • MDLEVEL_TYPE_WEEKS
  • MDLEVEL_TYPE_DAYS
  • MDLEVEL_TYPE_HOURS
  • MDLEVEL_TYPE_MINUTES
  • MDLEVEL_TYPE_SECONDS
  • MDLEVEL_TYPE_UNDEFINED
  • MDLEVEL_TYPE_UNKNOWN
 No
DESCRIPTION DBTYPE_WSTR Description of this level. No

Restricting Returned Rows

Restrictions enable an OLE DB consumer to restrict the rows that are returned in a schema rowset by IDBSchemaRowset::GetRowset. A restriction is a value for a specific column. When a restriction is passed to IDBSchemaRowset::GetRowset, all rows that are returned in the schema rowset must match the restriction value on the specified column. Restriction values do not support pattern matching or wildcards. For example, the restriction value D_F matches D_F but not DEF.

An OLE DB consumer can programmatically discover the columns on which the providers support restrictions by calling IDBSchemaRowset::GetSchemas.

Note: For definitions of the type indicators, see "Type Indicators" in Microsoft's OLE DB specification documentation.