select
c1aord.owner,
c1aord.cube_name,
c1aord.dimension_owner,
c1aord.dimension_name,
c1aord.position
from olapsys.cwm2$mrall_cwm1_aggord c1aord,
olapsys.olap_session_objects oso
where oso.version_id = c1aord.version_id and
oso.id = c1aord.id
SELECT
C1AORD.OWNER
,
C1AORD.CUBE_NAME
,
C1AORD.DIMENSION_OWNER
,
C1AORD.DIMENSION_NAME
,
C1AORD.POSITION
FROM OLAPSYS.CWM2$MRALL_CWM1_AGGORD C1AORD
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = C1AORD.VERSION_ID AND
OSO.ID = C1AORD.ID
|
|
|