select
c.owner owner,
c.name cube_name,
m.name measure_name,
d.owner dimension_owner,
d.name dimension_name,
null dimension_alias,
null default_aggr_function_use_id
from olapsys.CwM2$Cube c,
olapsys.CwM2$Dimension d,
olapsys.CwM2$Measure m,
olapsys.CwM2$CubeDimensionUse cdu
where c.irid = cdu.cube_irid and
d.irid = cdu.dimension_irid and
m.cube_irid = c.irid
with read only
SELECT
C.OWNER OWNER
,
C.NAME CUBE_NAME
,
M.NAME MEASURE_NAME
,
D.OWNER DIMENSION_OWNER
,
D.NAME DIMENSION_NAME
,
NULL DIMENSION_ALIAS
,
NULL DEFAULT_AGGR_FUNCTION_USE_ID
FROM OLAPSYS.CWM2$CUBE C
,
OLAPSYS.CWM2$DIMENSION D
,
OLAPSYS.CWM2$MEASURE M
,
OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
WHERE C.IRID = CDU.CUBE_IRID AND
D.IRID = CDU.DIMENSION_IRID AND
M.CUBE_IRID = C.IRID
WITH READ ONLY
|
|
|