select
au.OWNER,
au.CUBE_NAME,
au.DIMENSION_OWNER,
au.DIMENSION_NAME,
au.HIERARCHY_NAME,
au.DIM_HIER_COMBO_ID,
au.AGGREGATION_NAME,
au.AGGREGATION_ORDER,
au.TABLE_OWNER,
au.TABLE_NAME,
au.COLUMN_NAME
from olapsys.CWM2$MRALL_OLAP2_AGG_USES au,
olapsys.olap_session_objects oso
where oso.version_id = au.version_id and
oso.id = au.id
SELECT
AU.OWNER
,
AU.CUBE_NAME
,
AU.DIMENSION_OWNER
,
AU.DIMENSION_NAME
,
AU.HIERARCHY_NAME
,
AU.DIM_HIER_COMBO_ID
,
AU.AGGREGATION_NAME
,
AU.AGGREGATION_ORDER
,
AU.TABLE_OWNER
,
AU.TABLE_NAME
,
AU.COLUMN_NAME
FROM OLAPSYS.CWM2$MRALL_OLAP2_AGG_USES AU
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = AU.VERSION_ID AND
OSO.ID = AU.ID
|
|
|