DBA Data[Home] [Help]

VIEW: OLAPSYS.MRV$OLAP2_CUBE_MEASURES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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