SELECT
sch.physicalname owner
, cub.physicalname cube_name
, msr.physicalname measure_name
, msr.displayname display_name
, msr.description description
FROM
dba_users u
, cwm$model sch
, cwm$cube cub
, cwm$measure msr
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_irid
AND ( cwm$util.fact_table_visible(cub.irid) = 'Y'
OR EXISTS /* SELECT ANY TABLE */
(SELECT null FROM v$enabledprivs
WHERE priv_number = -47))
AND cub.irid = msr.itemcontainer_irid
WITH READ ONLY
SELECT
SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, MSR.PHYSICALNAME MEASURE_NAME
, MSR.DISPLAYNAME DISPLAY_NAME
, MSR.DESCRIPTION DESCRIPTION
FROM
DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$MEASURE MSR
WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_IRID
AND ( CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y'
OR EXISTS /* SELECT ANY TABLE */
(SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47))
AND CUB.IRID = MSR.ITEMCONTAINER_IRID
WITH READ ONLY
|
|
|