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:
|
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.