select owner, dimension_name, dim_attribute_name, level_name, lvl_attribute_name
from olapsys.dba$olap_dim_attr_uses
union all
select owner, dimension_name, dim_attribute_name, level_name, lvl_attribute_name
from dba$olap2_dim_attr_uses
with read only
SELECT OWNER
, DIMENSION_NAME
, DIM_ATTRIBUTE_NAME
, LEVEL_NAME
, LVL_ATTRIBUTE_NAME
FROM OLAPSYS.DBA$OLAP_DIM_ATTR_USES
UNION ALL
SELECT OWNER
, DIMENSION_NAME
, DIM_ATTRIBUTE_NAME
, LEVEL_NAME
, LVL_ATTRIBUTE_NAME
FROM DBA$OLAP2_DIM_ATTR_USES
WITH READ ONLY
|
|
|