VIEW: OLAPSYS.ALL$OLAP2UCATALOG_ENTITY_USES

Source

View Text - Preformatted

select distinct
  ce.classification_irid catalog_id
, sch.physicalname entity_owner
, cub.physicalname entity_name
, msr.physicalname child_entity_name
FROM
  cwm$classification c
, cwm$classificationentry ce
, cwm$classificationtype cty
, cwm$measure msr
, cwm$cube cub
, cwm$model sch
, dba_users u
, cwm$cubedimensionuse cdu
, cwm$dimension cd
, dba_users du
, sys.obj$ do
WHERE cty.irid = c.classificationtype_irid
AND cty.name = 'ORACLE_OLAP_CATALOG'
AND c.irid = ce.classification_irid
AND ce.name = 'MEASURE'
AND ce.element_irid = msr.irid
AND msr.itemcontainer_irid = cub.irid
AND sch.irid = cub.datamodel_irid
AND sch.physicalname = u.username
AND cdu.cube_irid = cub.irid
AND cdu.dimension_owner = du.username
AND cdu.dimension_name = do.name
AND du.user_id = do.owner#
AND do.obj# = cd.irid
AND do.type# = 43
AND cd.irid = cdu.abstractdimension_irid
AND (cwm$util.fact_table_visible(cub.irid) = 'Y'
     OR EXISTS /* SELECT ANY TABLE */
       (SELECT null FROM v$enabledprivs
        WHERE priv_number = -47))
union all
select catalog_id,
 entity_owner,
 entity_name,
 child_entity_name
from olapsys.all$olap2_catalog_entity_uses
with read only

View Text - HTML Formatted

SELECT DISTINCT CE.CLASSIFICATION_IRID CATALOG_ID
, SCH.PHYSICALNAME ENTITY_OWNER
, CUB.PHYSICALNAME ENTITY_NAME
, MSR.PHYSICALNAME CHILD_ENTITY_NAME FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM$MEASURE MSR
, CWM$CUBE CUB
, CWM$MODEL SCH
, DBA_USERS U
, CWM$CUBEDIMENSIONUSE CDU
, CWM$DIMENSION CD
, DBA_USERS DU
, SYS.OBJ$ DO WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP_CATALOG' AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'MEASURE' AND CE.ELEMENT_IRID = MSR.IRID AND MSR.ITEMCONTAINER_IRID = CUB.IRID AND SCH.IRID = CUB.DATAMODEL_IRID AND SCH.PHYSICALNAME = U.USERNAME AND CDU.CUBE_IRID = CUB.IRID AND CDU.DIMENSION_OWNER = DU.USERNAME AND CDU.DIMENSION_NAME = DO.NAME AND DU.USER_ID = DO.OWNER# AND DO.OBJ# = CD.IRID AND DO.TYPE# = 43 AND CD.IRID = CDU.ABSTRACTDIMENSION_IRID AND (CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y' OR EXISTS /* SELECT ANY TABLE */ (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47)) UNION ALL SELECT CATALOG_ID
, ENTITY_OWNER
, ENTITY_NAME
, CHILD_ENTITY_NAME FROM OLAPSYS.ALL$OLAP2_CATALOG_ENTITY_USES WITH READ ONLY