select
cm.owner owner,
cm.cube_name cube_name,
cm.measure_name measure_name,
cm.display_name display_name,
cm.shortdescription short_description,
cm.description description,
cm.cube_description cube_description
from olapsys.cwm2$mrall_cube_measures cm,
olapsys.olap_session_objects oso
where oso.version_id = cm.version_id and
oso.id = cm.id
SELECT
CM.OWNER OWNER
,
CM.CUBE_NAME CUBE_NAME
,
CM.MEASURE_NAME MEASURE_NAME
,
CM.DISPLAY_NAME DISPLAY_NAME
,
CM.SHORTDESCRIPTION SHORT_DESCRIPTION
,
CM.DESCRIPTION DESCRIPTION
,
CM.CUBE_DESCRIPTION CUBE_DESCRIPTION
FROM OLAPSYS.CWM2$MRALL_CUBE_MEASURES CM
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = CM.VERSION_ID AND
OSO.ID = CM.ID
|
|
|