Hierarchy table
DEPM_MOD_HIERARCHY table represents a parent-child hierarchy of a dimension.
| Name | Definition |
|---|---|
| Name | nvarchar(50) NOT NULL; PK |
| DimensionID | nvarchar(50) NOT NULL; PK |
| ElementsTableName | nvarchar(50) NULL |
| RelationsTableName | nvarchar(50) NULL |
| ExtendedProperties[DS1] (can contain Custom Settings) | ntext NULL |
| Type | int NULL |
| Definition | ntext NULL |
ExtendedProperties holds additional information about an OLAP hierarchy in the OLAP Extended Properties.xml format. Examples of the information that is held are the hierarchy caption, the hierarchy description, and their translations.
ElementTableName references a table from which the hierarchy elements are loaded. This property is valid only for hierarchy types 0 and 1.
RelationsTableName can be used to reference a table from which the hierarchy relations are loaded. This property is valid only for hierarchy type 0. If the relations are already part of the elements table, this property remains empty.
Type indicates the hierarchy type. Currently this is NULL or 0 for parent-child hierarchy. Other hierarchy types are not yet supported.
Definition is for future enhancements.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| DimensionID | _dimension | ID |
| ElementsTableName | _table | Name |
| RelationsTableName | _table | Name |