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

SCHEMA_NAME

DBTYPE_WSTR

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

CUBE_NAME

DBTYPE_WSTR

The name of the cube to which this level belongs.

DIMENSION_UNIQUE_NAME

DBTYPE_WSTR

The 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

DBTYPE_WSTR

The 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

The name of the level.

LEVEL_UNIQUE_NAME

DBTYPE_WSTR

The properly escaped unique name of the level.

LEVEL_GUID

DBTYPE_GUID

Not supported.

LEVEL_CAPTION

DBTYPE_WSTR

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

The distance of the level from the root of the hierarchy. Root level is zero (0).

LEVEL_CARDINALITY

DBTYPE_UI4

The number of members in the level.

LEVEL_TYPE

DBTYPE_I4

Type of the level:

MDLEVEL_TYPE_GEO_CONTINENT (0x2001)

MDLEVEL_TYPE_GEO_REGION (0x2002)

MDLEVEL_TYPE_GEO_COUNTRY (0x2003)

MDLEVEL_TYPE_GEO_STATE_OR_PROVINCE (0x2004)

MDLEVEL_TYPE_GEO_COUNTY (0x2005)

MDLEVEL_TYPE_GEO_CITY (0x2006)

MDLEVEL_TYPE_GEO_POSTALCODE (0x2007)

MDLEVEL_TYPE_GEO_POINT (0x2008)

MDLEVEL_TYPE_ORG_UNIT (0x1011)

MDLEVEL_TYPE_BOM_RESOURCE (0x1012)

MDLEVEL_TYPE_QUANTITATIVE (0x1013)

MDLEVEL_TYPE_ACCOUNT (0x1014)

MDLEVEL_TYPE_CUSTOMER (0x1021)

MDLEVEL_TYPE_CUSTOMER_GROUP (0x1022)

MDLEVEL_TYPE_CUSTOMER_HOUSEHOLD (0x1023)

MDLEVEL_TYPE_PRODUCT (0x1031)

MDLEVEL_TYPE_PRODUCT_GROUP (0x1032)

MDLEVEL_TYPE_SCENARIO (0x1015)

MDLEVEL_TYPE_UTILITY (0x1016)

MDLEVEL_TYPE_PERSON (0x1041)

MDLEVEL_TYPE_COMPANY (0x1042)

MDLEVEL_TYPE_CURRENCY_SOURCE (0x1051)

MDLEVEL_TYPE_CURRENCY_DESTINATION (0x1052)

MDLEVEL_TYPE_CHANNEL (0x1061)

MDLEVEL_TYPE_REPRESENTATIVE (0x1062)

MDLEVEL_TYPE_PROMOTION (0x1071)

DESCRIPTION

DBTYPE_WSTR

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

CUSTOM_ROLLUP_SETTINGS

DBTYPE_I4

A bitmap that specifies the custom rollup options:

MDLEVELS_CUSTOM_ROLLUP_EXPRESSION (0x01) indicates an expression exists for this level. (Deprecated)

MDLEVELS_CUSTOM_ROLLUP_COLUMN (0x02) indicates that there is a custom rollup column for this level.

MDLEVELS_SKIPPED_LEVELS (0x04) indicates that there is a skipped level associated with members of this level.

MDLEVELS_CUSTOM_MEMBER_PROPERTIES (0x08) indicates that members of the level have custom member properties.

MDLEVELS_UNARY_OPERATOR (0x10) indicates that members on the level have unary operators.

LEVEL_UNIQUE_SETTINGS

DBTYPE_I4

A bitmap that specifies which columns contain unique values, if the level only has members with unique names or keys. The Msmd.h file defines the following bit value constants for this bitmap:

MDDIMENSIONS_MEMBER_KEY_UNIQUE (1)

MDDIMENSIONS_MEMBER_NAME_UNIQUE (2)

The key is always unique in Microsoft SQL Server Analysis Services. The name will be unique if the setting on the attribute is UniqueInDimension or UniqueInAttribute

LEVEL_IS_VISIBLE

DBTYPE_BOOL

A Boolean that indicates whether the level is visible.

Always returns True. If the level is not visible, it will not be included in the schema rowset.

LEVEL_ORDERING_PROPERTY

DBTYPE_WSTR

The ID of the attribute that the level is sorted on.

LEVEL_DBTYPE

DBTYPE_I4

The DBTYPE enumeration of the member key column that is used for the level attribute.

Null if concatenated keys are used as the member key column.

LEVEL_MASTER_UNIQUE_NAME

DBTYPE_WSTR

Always returns NULL.

LEVEL_NAME_SQL_COLUMN_NAME

DBTYPE_WSTR

The SQL representation of the level member names.

LEVEL_KEY_SQL_COLUMN_NAME

DBTYPE_WSTR

The SQL representation of the level member key values.

LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME

DBTYPE_WSTR

The SQL representation of the member unique names.

LEVEL_ATTRIBUTE_HIERARCHY_NAME

DBTYPE_WSTR

The name of the attribute hierarchy providing the source of the level.