HIERARCHIES Rowset

The HIERARCHIES rowset contains information about the hierarchies available in a dimension. If the dimension does not contain a hierarchy or has just one hierarchy, the HIERARCHY_NAME column will contain a NULL, and both the HIERARCHY_UNIQUE_NAME and HIERARCHY_CAPTION columns will contain the name of the dimension. The rowset has the following structure:

Column name Type indicator Description
CATALOG_NAME DBTYPE_WSTR The name of the catalog to which this hierarchy belongs. NULL if the provider does not support catalogs.
SCHEMA_NAME DBTYPE_WSTR The name of the schema to which this hierarchy belongs. NULL if the provider does not support schemas.
CUBE_NAME DBTYPE_WSTR Name of the cube to which this hierarchy belongs.
DIMENSION_
UNIQUE_NAME
DBTYPE_WSTR Unique name of the dimension to which this hierarchy belongs. For providers that generate unique names by qualification, each component of this name is delimited.
HIERARCHY_NAME DBTYE_WSTR Name of the hierarchy. If the dimension does not contain a hierarchy or has just one hierarchy, this column contains a NULL.
HIERARCHY_
UNIQUE_NAME
DBTYPE_WSTR Unique name of the hierarchy. This must be an unambiguous name. If the dimension does not contain a hierarchy or has just one hierarchy, this column will contain the name of the dimension. For providers that generate unique names by qualification, each component of this name is delimited.
HIERARCHY_GUID DBTYPE_GUID Hierarchy GUID. NULL if there is no GUID.
HIERARCHY_CAPTION DBTYPE_WSTR A label or a caption associated with the hierarchy. Used primarily for display purposes. If a caption does not exist, HIERARCHY_NAME is returned. If the dimension does not contain a hierarchy or has just one hierarchy, this column will contain the name of the dimension.
DIMENSION_TYPE DBTYPE_I2 The type of the dimension to which this hierarchy belongs. Can be one of the following values:
  • MD_DIMTYPE_TIME. which indicates a time dimension.

  • MD_DIMTYPE_MEASURE. which indicates a measure dimension.

  • MD_DIMTYPE_OTHER. which indicates that the dimension is neither a time dimension nor a measure dimension.

  • MD_DIMTYPE_UNKNOWN, which indicates that the provider is unable to classify the dimension.

HIERARCHY_
CARDINALITY
DBTYPE_UI4 The number of members in the hierarchy. Because of the presence of multiple hierarchies, this number may not be the same as DIMENSION_CARDINALITY. Note that this value can be an approximation of the real cardinality. Consumers should not rely on this being accurate.
DEFAULT_MEMBER DBTYPE_WSTR The default member for this hierarchy. This is a unique name. Note that every hierarchy has to have a default member.
ALL_MEMBER DBTYPE_WSTR This is the member at the highest level of rollup in the hierarchy. Note that this can be different from DEFAULT_MEMBER.
DESCRIPTION DBTYPE_WSTR A human-readable description of the hierarchy. NULL if no description exists.

The default sort order is: CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, DIMENSION_UNIQUE_NAME, and HIERARCHY_NAME.