LEVELS Rowset

  • Article

The LEVELS rowset contains information about the levels available in a dimension.

The default sort order is CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, DIMENSION_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, and LEVEL_NUMBER.

The rowset structure is described in the following table.

Column name

Type indicator

Description

CATALOG_NAME

DBTYPE_WSTR

Optional. The name of the catalog to which this level belongs. NULL if the provider does not support catalogs.

SCHEMA_NAME

DBTYPE_WSTR

Optional. The name of the schema to which this level belongs. NULL if the provider does not support schemas.

CUBE_NAME

DBTYPE_WSTR

Required. Name of the cube to which this level belongs.

DIMENSION_UNIQUE_NAME

DBTYPE_WSTR

Required. Unique name of the dimension to which this level belongs. For providers that generate unique names by qualification, each component of this name is delimited.

HIERARCHY_UNIQUE_NAME

DBTYE_WSTR

Required. Unique name of the hierarchy. If the level belongs to more than one hierarchy, there is one row for each hierarchy to which it belongs. For providers that generate unique names by qualification, each component of this name is delimited.

LEVEL_NAME

DBTYPE_WSTR

Required. Name of the level.

LEVEL_UNIQUE_NAME

DBTYPE_WSTR

Required. Unique name of the level. For providers that generate unique names by qualification, each component of this name is delimited.

LEVEL_GUID

DBTYPE_GUID

Optional. Level GUID. NULL if the level does not have a GUID.

LEVEL_CAPTION

DBTYPE_WSTR

Required. A label or caption associated with the hierarchy. Used primarily for display purposes. If a caption does not exist, LEVEL_NAME is returned.

LEVEL_NUMBER

DBTYPE_UI4

Required. The distance of the level from the root of the hierarchy. The root level is zero.

LEVEL_CARDINALITY

DBTYPE_UI4

Required. The number of members in a level. This value can be an approximation of the real cardinality. Consumers should not assume that this value is accurate.

LEVEL_TYPE

DBTYPE_I4

Required. The following bitmasks are used to specify the level characteristics:

  • MDLEVEL_TYPE_REGULAR

  • MDLEVEL_TYPE_ALL

  • MDLEVEL_TYPE_CALCULATED

  • MDLEVEL_TYPE_TIME

  • MDLEVEL_TYPE_TIME_YEARS

  • MDLEVEL_TYPE_TIME_HALF_YEAR

  • MDLEVEL_TYPE_TIME_QUARTERS

  • MDLEVEL_TYPE_TIME_MONTHS

  • MDLEVEL_TYPE_TIME_WEEKS

  • MDLEVEL_TYPE_TIME_DAYS

  • MDLEVEL_TYPE_TIME_HOURS

  • MDLEVEL_TYPE_TIME_MINUTES

  • MDLEVEL_TYPE_TIME_SECONDS

  • MDLEVEL_TYPE_TIME_UNDEFINED

  • MDLEVEL_TYPE_UNKNOWN

NoteNote
The LEVEL_TYPE column exists mainly as a means to transmit formatting instructions to an application. For example, a level with a type of LEVEL_TYPE_TIME_DAYS might indicate to an application that the members of the level should be expressed in text format (that is, "Sunday", "Monday", "Tuesday", and so on). LEVEL_TYPE_REGULAR can be used to signify a level that does not require any special formatting.

DESCRIPTION

DBTYPE_WSTR

Optional. A human-readable description of the level. NULL if no description exists.