../E40402-16.epub /> ../E40402-16.mobi />

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(30) NOT NULL Owner of the dimension
DIMENSION_NAME VARCHAR2(30) NOT NULL Name of the dimension
LEVEL_NAME VARCHAR2(30)   Name of the hierarchy level
KEY_POSITION NUMBER NOT NULL Ordinal position of the key column within the level
COLUMN_NAME VARCHAR2(30) NOT NULL Name of the key column