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 |