ALL_OLAP2_FACT_LEVEL_USES

ALL_OLAP2_FACT_LEVEL_USES shows the joins between dimension tables and fact tables in a star or snowflake schema. For more information, see "Joining Fact Tables with Dimension Tables".

Column	Data Type	NULL	Description
`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).
`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.