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)
|
NOT NULL
|
Name of the level within the hierarchy where the mapping occurs. This represents the lowest level of aggregation defined by the foreign key/primary key for a specific dimension of the cube.
|
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 data is stored in the key column. The fact table is unsolved.
ET (Embedded Totals), when 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 each level is stored in a separate key column (multi-column key).
|
FOREIGN_KEY_NAME
|
VARCHAR2(30)
|
|
Name of the foreign key constraint (OLAP 1 Catalog only) applied to the foreign key column. Constraints are not used in the OLAP 2 Catalog.
|