select
owner,
cube_name,
dimension_owner,
dimension_name,
hierarchy_name,
dim_hier_combo_id,
fact_table_owner,
fact_table_name,
column_name
from dba$olap2_fact_table_gid
with read only
View Text - HTML Formatted
SELECT
OWNER ,
CUBE_NAME ,
DIMENSION_OWNER ,
DIMENSION_NAME ,
HIERARCHY_NAME ,
DIM_HIER_COMBO_ID ,
FACT_TABLE_OWNER ,
FACT_TABLE_NAME ,
COLUMN_NAME
FROM DBA$OLAP2_FACT_TABLE_GID
WITH READ ONLY