VIEW: OLAPSYS.EXPORT_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_OLAP_CATALOG'
AND c.irid = ce.element_irid
AND ce.name = 'CATALOG'
AND ce.classification_irid = cp.irid
UNION ALL SELECT
  c.irid catalog_id
, c.name catalog_name
, null parent_catalog_id
, c.description description
, 'CATALOG' entry_name -- added
FROM
  olapsys.cwm$classification c
, olapsys.cwm$classificationtype cty
WHERE cty.irid = c.classificationtype_irid
AND cty.name = 'ORACLE_OLAP_CATALOG'
AND NOT EXISTS
    (SELECT null
    FROM olapsys.cwm$classificationentry ce
    WHERE ce.name = 'CATALOG'
    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_OLAP_CATALOG' AND C.IRID = CE.ELEMENT_IRID AND CE.NAME = 'CATALOG' AND CE.CLASSIFICATION_IRID = CP.IRID UNION ALL SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, NULL PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION
, 'CATALOG' ENTRY_NAME -- ADDED FROM OLAPSYS.CWM$CLASSIFICATION C
, OLAPSYS.CWM$CLASSIFICATIONTYPE CTY WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP_CATALOG' AND NOT EXISTS (SELECT NULL
FROM OLAPSYS.CWM$CLASSIFICATIONENTRY CE
WHERE CE.NAME = 'CATALOG'
AND CE.ELEMENT_IRID = C.IRID) WITH READ ONLY