2.121 ALL_DIM_LEVEL_KEY

ALL_DIM_LEVEL_KEY describes a column of a dimension level accessible to the current user. The position of a column within a level is specified by KEY_POSITION.

Related Views

  • DBA_DIM_LEVEL_KEY describes all columns of dimension levels in the database.

  • USER_DIM_LEVEL_KEY describes all columns of dimension levels owned by the current user.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(128)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(128)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the key column