select
c1aop.owner,
c1aop.cube_name,
c1aop.measure_name,
c1aop.dimension_owner,
c1aop.dimension_name,
c1aop.func_name,
c1aop.table_owner,
c1aop.table_name,
c1aop.column_name
from olapsys.cwm2$mrall_cwm1_aggop c1aop,
olapsys.olap_session_objects oso
where oso.version_id = c1aop.version_id and
oso.id = c1aop.id
SELECT
C1AOP.OWNER
,
C1AOP.CUBE_NAME
,
C1AOP.MEASURE_NAME
,
C1AOP.DIMENSION_OWNER
,
C1AOP.DIMENSION_NAME
,
C1AOP.FUNC_NAME
,
C1AOP.TABLE_OWNER
,
C1AOP.TABLE_NAME
,
C1AOP.COLUMN_NAME
FROM OLAPSYS.CWM2$MRALL_CWM1_AGGOP C1AOP
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = C1AOP.VERSION_ID AND
OSO.ID = C1AOP.ID
|
|
|