DBA Data[Home] [Help]

VIEW: OLAPSYS.MRV$OLAP2_CATALOG_ENTITY_USES

Source

View Text - Preformatted

select
  ceu.catalog_id catalog_id,
  ceu.entity_owner entity_owner,
  ceu.entity_name entity_name,
  ceu.child_entity_name child_entity_name
 from olapsys.cwm2$mrall_catalog_entity_uses ceu,
      olapsys.olap_session_objects oso
 where oso.version_id = ceu.version_id and
       oso.id = ceu.id
View Text - HTML Formatted

SELECT CEU.CATALOG_ID CATALOG_ID
, CEU.ENTITY_OWNER ENTITY_OWNER
, CEU.ENTITY_NAME ENTITY_NAME
, CEU.CHILD_ENTITY_NAME CHILD_ENTITY_NAME
FROM OLAPSYS.CWM2$MRALL_CATALOG_ENTITY_USES CEU
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = CEU.VERSION_ID AND OSO.ID = CEU.ID