Table: ALL_DIM_CHILD_OF
Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
| Column Name | Description |
|---|---|
| CHILD_LEVEL_NAME | Name of the child-side level of this 1:n relationship |
| DIMENSION_NAME | Name of the dimension |
| HIERARCHY_NAME | Name of the hierarchy |
| JOIN_KEY_ID | Keys that join child uniquely to the parent |
| OWNER | Owner of the dimension |
| PARENT_LEVEL_NAME | Name of the parent-side level of this 1:n relationship |
| POSITION | Hierarchical position within this hierarchy, position 1 being the most detailed |