_HierarchyLevelNames
The _HierarchyLevelNames table stores the levels in the hierarchies that the combined table columns represent.
This table describes _HierarchyLevelNames:
| Column | Type | Description |
|---|---|---|
| DimensionName | String(50) | Name of dimension. |
| HierarchyName | String(50) | Name of hierarchy. |
| LevelNumber | Integer | Number of the level. |
| LevelName | String(50) | Name of the level. |
| ColumnName | String(50) | When the related hierarchy has a HierarchyType = 0, this is the name of the relational source column.
ColumnName can be NULL for a Hierarchy with the same name as the dimension. ColumnName must be NULL for the top level in a star schema Hierarchy (‘combined table’) |
| Comment | Text | User defined comment. |