DBA Data[Home] [Help]

VIEW: OLAPSYS.DBA$OLAP2_CUBE_MEASURES

Source

View Text - Preformatted

select
  c.owner owner,
  c.name cube_name,
  m.name measure_name,
  m.displayname display_name,
  m.shortdescription short_description,
  m.description description
from olapsys.CwM2$Cube c,
     olapsys.CwM2$Measure m
where c.irid = m.cube_irid
with read only
View Text - HTML Formatted

SELECT C.OWNER OWNER
, C.NAME CUBE_NAME
, M.NAME MEASURE_NAME
, M.DISPLAYNAME DISPLAY_NAME
, M.SHORTDESCRIPTION SHORT_DESCRIPTION
, M.DESCRIPTION DESCRIPTION FROM OLAPSYS.CWM2$CUBE C
, OLAPSYS.CWM2$MEASURE M WHERE C.IRID = M.CUBE_IRID WITH READ ONLY