LEVELS Schema Rowset

Standard Mapping

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.

Standard Mapping

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. These are the types: 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

Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.