select
c.owner owner,
c.name cube_name,
d.owner dimension_owner,
d.name dimension_name,
(case when h.hidden = 'N'
then h.name else null end) hierarchy_name,
fdhm.irid dim_hier_combo_id,
f.name aggregation_name,
fkdhm.aggorder aggregation_order,
u.username table_owner,
o.name table_name,
col.name column_name
from olapsys.CwM2$Cube c,
olapsys.CwM2$Dimension d,
olapsys.CwM2$CubeDimensionUse cdu,
olapsys.CwM2$FactDimHierMap fdhm,
olapsys.CwM2$FactDimHierTplsDtl fdhtd,
olapsys.CwM2$FactKeyDimHierMap fkdhm,
olapsys.CwM2$Hierarchy h,
olapsys.cwm$Function f,
sys.obj$ o,
dba_users u,
sys.col$ col
where c.irid = cdu.cube_irid and
d.irid = cdu.dimension_irid and
h.dimension_irid = d.irid and
fdhm.cube_irid = c.irid and
fkdhm.factDimHier_IRID = fdhm.irid and
fkdhm.dimension_irid = d.irid and
fdhm.irid = fdhtd.factdimhier_irid and
h.irid = fdhtd.hier_irid and
fkdhm.aggoperator_irid = f.irid and
u.user_id = o.owner# and
o.obj# = col.obj# and
col.col# = fkdhm.AggWeightCol_ID and
col.obj# = fkdhm.AggWeightTbl_ID 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
,
D.OWNER DIMENSION_OWNER
,
D.NAME DIMENSION_NAME
,
(CASE WHEN H.HIDDEN = 'N'
THEN H.NAME ELSE NULL END) HIERARCHY_NAME
,
FDHM.IRID DIM_HIER_COMBO_ID
,
F.NAME AGGREGATION_NAME
,
FKDHM.AGGORDER AGGREGATION_ORDER
,
U.USERNAME TABLE_OWNER
,
O.NAME TABLE_NAME
,
COL.NAME COLUMN_NAME
FROM OLAPSYS.CWM2$CUBE C
,
OLAPSYS.CWM2$DIMENSION D
,
OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
,
OLAPSYS.CWM2$FACTDIMHIERMAP FDHM
,
OLAPSYS.CWM2$FACTDIMHIERTPLSDTL FDHTD
,
OLAPSYS.CWM2$FACTKEYDIMHIERMAP FKDHM
,
OLAPSYS.CWM2$HIERARCHY H
,
OLAPSYS.CWM$FUNCTION F
,
SYS.OBJ$ O
,
DBA_USERS U
,
SYS.COL$ COL
WHERE C.IRID = CDU.CUBE_IRID AND
D.IRID = CDU.DIMENSION_IRID AND
H.DIMENSION_IRID = D.IRID AND
FDHM.CUBE_IRID = C.IRID AND
FKDHM.FACTDIMHIER_IRID = FDHM.IRID AND
FKDHM.DIMENSION_IRID = D.IRID AND
FDHM.IRID = FDHTD.FACTDIMHIER_IRID AND
H.IRID = FDHTD.HIER_IRID AND
FKDHM.AGGOPERATOR_IRID = F.IRID AND
U.USER_ID = O.OWNER# AND
O.OBJ# = COL.OBJ# AND
COL.COL# = FKDHM.AGGWEIGHTCOL_ID AND
COL.OBJ# = FKDHM.AGGWEIGHTTBL_ID 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
|
|
|