VIEW: OLAPSYS.DBA$OLAP_CATALOG_ENTITY_USES

Source

View Text - Preformatted

SELECT
  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
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 cub.datamodel_irid = sch.irid
AND sch.physicalname = u.username
WITH READ ONLY

View Text - HTML Formatted

SELECT 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 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 CUB.DATAMODEL_IRID = SCH.IRID AND SCH.PHYSICALNAME = U.USERNAME WITH READ ONLY