VIEW: OLAPSYS.EXPORT2_CATALOGS

Source

View Text - Preformatted

select
 c.irid catalog_id,
 c.name catalog_name,
 cp.irid parent_catalog_id,
 c.description description,
 ce.name entry_name -- added for export
from
 olapsys.cwm$classification c,
 olapsys.cwm$classification cp,
 olapsys.cwm$classificationtype cty,
 olapsys.cwm$classificationentry ce
where cty.irid = c.classificationtype_irid and
      cty.name = 'ORACLE_OLAP2_CATALOG' and
      c.irid = ce.element_irid and
      ce.name = 'CATALOG2' and
      ce.classification_irid = cp.irid
UNION ALL select
 c.irid catalog_id,
 c.name catalog_name,
 null parent_catalog_id,
 c.description description,
 'CATALOG2' entry_name -- added
from
 olapsys.cwm$classification c,
 olapsys.cwm$classificationtype cty
where cty.irid = c.classificationtype_irid and
      cty.name = 'ORACLE_OLAP2_CATALOG' and
      NOT EXISTS
       (select null from olapsys.cwm$classificationentry ce
        where ce.name = 'CATALOG2' and
              ce.element_irid = c.irid)
with read only

View Text - HTML Formatted

SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, CP.IRID PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION
, CE.NAME ENTRY_NAME -- ADDED FOR EXPORT FROM OLAPSYS.CWM$CLASSIFICATION C
, OLAPSYS.CWM$CLASSIFICATION CP
, OLAPSYS.CWM$CLASSIFICATIONTYPE CTY
, OLAPSYS.CWM$CLASSIFICATIONENTRY CE WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP2_CATALOG' AND C.IRID = CE.ELEMENT_IRID AND CE.NAME = 'CATALOG2' AND CE.CLASSIFICATION_IRID = CP.IRID UNION ALL SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, NULL PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION
, 'CATALOG2' ENTRY_NAME -- ADDED FROM OLAPSYS.CWM$CLASSIFICATION C
, OLAPSYS.CWM$CLASSIFICATIONTYPE CTY WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP2_CATALOG' AND NOT EXISTS (SELECT NULL
FROM OLAPSYS.CWM$CLASSIFICATIONENTRY CE
WHERE CE.NAME = 'CATALOG2' AND CE.ELEMENT_IRID = C.IRID) WITH READ ONLY