2.118 ALL_DIM_CHILD_OF

ALL_DIM_CHILD_OF describes hierarchical relationships of 1 to n between the pairs of levels in the dimensions accessible to the current user.

Related Views

  • DBA_DIM_CHILD_OF describes all such hierarchical relationships in the database.

  • USER_DIM_CHILD_OF describes all such hierarchical attributes in the current user's schema.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(128)

NOT NULL

Name of the dimension

HIERARCHY_NAME

VARCHAR2(128)

Hierarchy name

POSITION

NUMBER

NOT NULL

Hierarchical position within this hierarchy, position 1 being the most detailed

CHILD_LEVEL_NAME

VARCHAR2(128)

Child side of 1:n relationship

JOIN_KEY_ID

VARCHAR2(40)

If non-null, then the child joins to the parent

PARENT_LEVEL_NAME

VARCHAR2(128)

Parent side of 1:n relationship in relation to the CHILD_LEVEL_NAME