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
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
|
|
|