VIEW: OLAPSYS.ALL$OLAP2_CATALOG_ENTITY_USES

Source

View Text - Preformatted

select
 ce.classification_irid catalog_id,
 cub.owner entity_owner,
 cub.name entity_name,
 meas.name child_entity_name
from /* MEASURES */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$measure meas,
 cwm2$cube cub
where cty.irid = c.classificationtype_irid and
      cty.name = 'ORACLE_OLAP2_CATALOG' and
      c.irid = ce.classification_irid and
      ce.name = 'MEASURE2' and
      ce.element_irid = meas.irid and
      meas.cube_irid = cub.irid and
      (cub.invalid = 'N' or cub.invalid = 'O') and
      (cwm2$security.fact_table_visible(cub.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47)))
with read only

View Text - HTML Formatted

SELECT CE.CLASSIFICATION_IRID CATALOG_ID
, CUB.OWNER ENTITY_OWNER
, CUB.NAME ENTITY_NAME
, MEAS.NAME CHILD_ENTITY_NAME FROM /* MEASURES */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$MEASURE MEAS
, CWM2$CUBE CUB WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP2_CATALOG' AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'MEASURE2' AND CE.ELEMENT_IRID = MEAS.IRID AND MEAS.CUBE_IRID = CUB.IRID AND (CUB.INVALID = 'N' OR CUB.INVALID = 'O') AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) WITH READ ONLY