ALL_OLAP2_CUBE_MEASURE_MAPS

Shows the mapping of each measure to a column.

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS

Shows the mapping of each level attribute to a column.

ALL_OLAP2_LEVEL_KEY_COLUMN_USES

Shows the mapping of each level to a unique key column.

ALL_OLAP2_JOIN_KEY_COLUMN_USES

Shows the joins between two levels in a hierarchy.

ALL_OLAP2_HIER_CUSTOM_SORT

Shows the default sort order for level columns within hierarchies.

ALL_OLAP2_FACT_TABLE_GID

Shows the Grouping ID column for each hierarchy in each fact table.

ALL_OLAP2_FACT_LEVEL_USES

Shows the joins between dimension tables and fact tables in a star or snowflake schema.