VIEW: OLAPSYS.ALL$OLAP2_ENTITY_DESC_USES

Source

View Text - Preformatted

select
 ce.classification_irid descriptor_id,
 cub.owner entity_owner,
 cub.name entity_name,
 null child_entity_name,
 null secondary_child_entity_name
from /* CUBE2 */
  cwm$classification c,
  cwm$classificationentry ce,
  cwm$classificationtype cty,
  cwm2$cube cub
where cty.irid = c.classificationtype_irid and
      cty.name <> 'ORACLE_OLAP2_CATALOG' and
      c.irid = ce.classification_irid and
      ce.name = 'CUBE2' and
      ce.element_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)))
UNION ALL select
 ce.classification_irid descriptor_id,
 cub.owner entity_owner,
 cub.name entity_name,
 meas.name child_entity_name,
 null secondary_child_entity_name
from /* MEASURE2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$cube cub,
 cwm2$measure meas
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)))
UNION ALL select
 ce.classification_irid descriptor_id,
 dim.owner entity_owner,
 dim.name entity_name,
 dat.name child_entity_name,
 null secondary_child_entity_name
from /* DIMENSION ATTRIBUTE2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$dimension dim,
 cwm2$dimensionattribute dat
where cty.irid = c.classificationtype_irid and
      cty.name <> 'ORACLE_OLAP2_CATALOG' and
      c.irid = ce.classification_irid and
      ce.name = 'DIMENSION ATTRIBUTE2' and
      ce.element_irid = dat.irid and
      dat.dimension_irid = dim.irid and
      dim.invalid = 'N' and
      (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
UNION ALL select
 ce.classification_irid descriptor_id,
 dim.owner entity_owner,
 dim.name entity_name,
 lvl.name child_entity_name,
 lat.name secondary_child_entity_name
from /* LEVEL ATTRIBUTE2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$dimension dim,
 cwm2$dimensionattribute dat,
 cwm2$levelattribute lat,
 cwm2$level lvl
where cty.irid = c.classificationtype_irid and
      cty.name not in ('ORACLE_OLAP2_CATALOG',
                       'ORACLE_OLAP_CATALOG') and
      c.irid = ce.classification_irid and
      ce.name = 'LEVEL ATTRIBUTE2' and
      ce.element_irid = lat.irid and
      lat.dimattr_irid = dat.irid and
      dat.dimension_irid = dim.irid and
      lvl.irid = lat.level_irid and
      dim.invalid = 'N' and
      (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
UNION ALL select
 ce.classification_irid descriptor_id,
 dim.owner entity_owner,
 dim.name entity_name,
 ce.secondary_object_name child_entity_name,
 null secondary_child_entity_name
from /* DIMENSION2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$dimension dim
where cty.irid = c.classificationtype_irid and
      cty.name not in ('ORACLE_OLAP2_CATALOG',
                       'ORACLE_OLAP_CATALOG') and
      c.irid = ce.classification_irid and
      ce.name  = 'DIMENSION2' and
      ce.element_irid = dim.irid and
      dim.invalid = 'N' and
      (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
UNION ALL select
 ce.classification_irid descriptor_id,
 dim.owner entity_owner,
 dim.name entity_name,
 hier.name child_entity_name,
 null secondary_child_entity_name
from /* HIERARCHY2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$dimension dim,
 cwm2$hierarchy hier
where cty.irid = c.classificationtype_irid and
      cty.name not in ('ORACLE_OLAP2_CATALOG',
                       'ORACLE_OLAP_CATALOG') and
      c.irid = ce.classification_irid and
      ce.name  = 'HIERARCHY2' and
      dim.irid = hier.dimension_irid and
      ce.element_irid = hier.irid and
      dim.invalid = 'N' and
      (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
UNION ALL select
 ce.classification_irid descriptor_id,
 dim.owner entity_owner,
 dim.name entity_name,
 lvl.name child_entity_name,
 null secondary_child_entity_name
from /* LEVEL2 */
 cwm$classification c,
 cwm$classificationentry ce,
 cwm$classificationtype cty,
 cwm2$dimension dim,
 cwm2$level lvl
where cty.irid = c.classificationtype_irid and
      cty.name not in ('ORACLE_OLAP2_CATALOG',
                       'ORACLE_OLAP_CATALOG') and
      c.irid = ce.classification_irid and
      ce.name  = 'LEVEL2' and
      dim.irid = lvl.dimension_irid and
      ce.element_irid = lvl.irid and
      dim.invalid = 'N' and
      (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
with read only

View Text - HTML Formatted

SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, CUB.OWNER ENTITY_OWNER
, CUB.NAME ENTITY_NAME
, NULL CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* CUBE2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$CUBE CUB WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME <> 'ORACLE_OLAP2_CATALOG' AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'CUBE2' AND CE.ELEMENT_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))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, CUB.OWNER ENTITY_OWNER
, CUB.NAME ENTITY_NAME
, MEAS.NAME CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* MEASURE2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$CUBE CUB
, CWM2$MEASURE MEAS 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))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, DIM.OWNER ENTITY_OWNER
, DIM.NAME ENTITY_NAME
, DAT.NAME CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* DIMENSION ATTRIBUTE2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$DIMENSION DIM
, CWM2$DIMENSIONATTRIBUTE DAT WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME <> 'ORACLE_OLAP2_CATALOG' AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'DIMENSION ATTRIBUTE2' AND CE.ELEMENT_IRID = DAT.IRID AND DAT.DIMENSION_IRID = DIM.IRID AND DIM.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, DIM.OWNER ENTITY_OWNER
, DIM.NAME ENTITY_NAME
, LVL.NAME CHILD_ENTITY_NAME
, LAT.NAME SECONDARY_CHILD_ENTITY_NAME FROM /* LEVEL ATTRIBUTE2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$DIMENSION DIM
, CWM2$DIMENSIONATTRIBUTE DAT
, CWM2$LEVELATTRIBUTE LAT
, CWM2$LEVEL LVL WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME NOT IN ('ORACLE_OLAP2_CATALOG'
, 'ORACLE_OLAP_CATALOG') AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'LEVEL ATTRIBUTE2' AND CE.ELEMENT_IRID = LAT.IRID AND LAT.DIMATTR_IRID = DAT.IRID AND DAT.DIMENSION_IRID = DIM.IRID AND LVL.IRID = LAT.LEVEL_IRID AND DIM.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, DIM.OWNER ENTITY_OWNER
, DIM.NAME ENTITY_NAME
, CE.SECONDARY_OBJECT_NAME CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* DIMENSION2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$DIMENSION DIM WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME NOT IN ('ORACLE_OLAP2_CATALOG'
, 'ORACLE_OLAP_CATALOG') AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'DIMENSION2' AND CE.ELEMENT_IRID = DIM.IRID AND DIM.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, DIM.OWNER ENTITY_OWNER
, DIM.NAME ENTITY_NAME
, HIER.NAME CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* HIERARCHY2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$DIMENSION DIM
, CWM2$HIERARCHY HIER WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME NOT IN ('ORACLE_OLAP2_CATALOG'
, 'ORACLE_OLAP_CATALOG') AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'HIERARCHY2' AND DIM.IRID = HIER.DIMENSION_IRID AND CE.ELEMENT_IRID = HIER.IRID AND DIM.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) UNION ALL SELECT CE.CLASSIFICATION_IRID DESCRIPTOR_ID
, DIM.OWNER ENTITY_OWNER
, DIM.NAME ENTITY_NAME
, LVL.NAME CHILD_ENTITY_NAME
, NULL SECONDARY_CHILD_ENTITY_NAME FROM /* LEVEL2 */ CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONENTRY CE
, CWM$CLASSIFICATIONTYPE CTY
, CWM2$DIMENSION DIM
, CWM2$LEVEL LVL WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME NOT IN ('ORACLE_OLAP2_CATALOG'
, 'ORACLE_OLAP_CATALOG') AND C.IRID = CE.CLASSIFICATION_IRID AND CE.NAME = 'LEVEL2' AND DIM.IRID = LVL.DIMENSION_IRID AND CE.ELEMENT_IRID = LVL.IRID AND DIM.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) WITH READ ONLY