VIEW: OLAPSYS.EXPORT2_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,
 ce.name entry_name -- added for export
from /* MEASURES */
 olapsys.cwm$classification c,
 olapsys.cwm$classificationentry ce,
 olapsys.cwm$classificationtype cty,
 olapsys.cwm2$measure meas,
 olapsys.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
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
, CE.NAME ENTRY_NAME -- ADDED FOR EXPORT FROM /* MEASURES */ OLAPSYS.CWM$CLASSIFICATION C
, OLAPSYS.CWM$CLASSIFICATIONENTRY CE
, OLAPSYS.CWM$CLASSIFICATIONTYPE CTY
, OLAPSYS.CWM2$MEASURE MEAS
, OLAPSYS.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 WITH READ ONLY