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 and
(c.invalid = 'N' or c.invalid = 'O') and
(cwm2$security.fact_table_visible(c.irid) = 'Y'
OR EXISTS (select null from v$enabledprivs
where priv_number in (-47)))
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 AND
(C.INVALID = 'N' OR C.INVALID = 'O') AND
(CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y'
OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47)))
WITH READ ONLY
|
|
|