OWNER

VARCHAR2(30)

NOT NULL

Owner of the cube.

CUBE_NAME

VARCHAR2(30)

NOT NULL

Name of the cube.

DIMENSION_OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

NUMBER

NOT NULL

Name of the dimension.

DIMENSION_ALIAS

VARCHAR2(30)

Dimension alias (if applicable).

HIERARCHY_NAME

NOT NULL

Name of the hierarchy.

DIM_HIER_COMBO_ID

NUMBER

NOT NULL

ID of the dimension hierarchy combination associated with this fact table.

LEVEL_NAME

VARCHAR2(30)

Name of the level within the hierarchy where the mapping occurs.

FACT_TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the fact table.

FACT_TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the fact table.

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the foreign key column in the fact table.

POSITION

NUMBER

Position of this column within a multi-column key.

DIMENSION_KEYMAP_TYPE

VARCHAR2(30)

NOT NULL

Type of key mapping for the fact table. Values may be:

LL (Lowest Level), when only lowest-level dimension members are stored in the key column. The fact table is unsolved.

ET (Embedded Totals), when dimension members for all level combinations are stored in the key column. The fact table is solved (contains embedded totals for all level combinations).

RU (Rolled Up), when dimension members for each level are stored in a separate key column (multi-column key).

FOREIGN_KEY_NAME

VARCHAR2(30)

Name of the foreign key constraint applied to the foreign key column. Constraints are not used by the CWM2 APIs.