VIEW: OLAPSYS.ALL$AW_LOAD_CUBE_AGG_MEASURES

Source

View Text - Preformatted

select c.owner cube_owner,
          c.name cube_name,
          cl.name load_name,
          cagg.name aggregation_name,
          m.name measure_name
   from
     cwm2$cube c,
     cwm2$measure m,
     cwm2$awcubeload cl,
     cwm2$awcubeagg cagg,
     cwm2$awcubeaggmeasure cagm,
     cwm2$awcubeloadaggplan clap
   where
     cl.cube_irid = c.irid and
     cl.version_id = 'CWM2' and
     (c.invalid = 'N' or c.invalid = 'O') and
     cagm.cubeagg_irid = cagg.irid and
     clap.cubeagg_irid = cagg.irid and
     clap.cubeload_irid = cl.irid and
     cagm.measure_irid = m.irid and
     m.cube_irid = c.irid and
     (cwm2$security.fact_table_visible(c.irid) = 'Y'
        OR EXISTS (select null from v$enabledprivs
                   where priv_number in (-47)))
  union all
   select sch.physicalname cube_owner,
          c.physicalname cube_name,
          cl.name load_name,
          cagg.name aggregation_name,
          m.physicalname measure_name
   from
      cwm$cube c,
      cwm$measure m,
      cwm$model sch,
      cwm2$awcubeload cl,
      cwm2$awcubeagg cagg,
      cwm2$awcubeaggmeasure cagm,
      cwm2$awcubeloadaggplan clap
   where
      cl.cube_irid = c.irid and
      cl.version_id = 'CWM' and
      cagm.cubeagg_irid = cagg.irid and
      clap.cubeagg_irid = cagg.irid and
      clap.cubeload_irid = cl.irid and
      cagm.measure_irid = m.irid and
      m.itemcontainer_irid = c.irid and
      sch.irid = c.datamodel_irid and
      (cwm$util.fact_table_visible(c.irid) = 'Y'
        OR EXISTS (select null from v$enabledprivs
                   where priv_number in (-47)))
with read only

View Text - HTML Formatted

SELECT C.OWNER CUBE_OWNER
, C.NAME CUBE_NAME
, CL.NAME LOAD_NAME
, CAGG.NAME AGGREGATION_NAME
, M.NAME MEASURE_NAME FROM CWM2$CUBE C
, CWM2$MEASURE M
, CWM2$AWCUBELOAD CL
, CWM2$AWCUBEAGG CAGG
, CWM2$AWCUBEAGGMEASURE CAGM
, CWM2$AWCUBELOADAGGPLAN CLAP WHERE CL.CUBE_IRID = C.IRID AND CL.VERSION_ID = 'CWM2' AND (C.INVALID = 'N' OR C.INVALID = 'O') AND CAGM.CUBEAGG_IRID = CAGG.IRID AND CLAP.CUBEAGG_IRID = CAGG.IRID AND CLAP.CUBELOAD_IRID = CL.IRID AND CAGM.MEASURE_IRID = M.IRID AND M.CUBE_IRID = C.IRID AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) UNION ALL SELECT SCH.PHYSICALNAME CUBE_OWNER
, C.PHYSICALNAME CUBE_NAME
, CL.NAME LOAD_NAME
, CAGG.NAME AGGREGATION_NAME
, M.PHYSICALNAME MEASURE_NAME FROM CWM$CUBE C
, CWM$MEASURE M
, CWM$MODEL SCH
, CWM2$AWCUBELOAD CL
, CWM2$AWCUBEAGG CAGG
, CWM2$AWCUBEAGGMEASURE CAGM
, CWM2$AWCUBELOADAGGPLAN CLAP WHERE CL.CUBE_IRID = C.IRID AND CL.VERSION_ID = 'CWM' AND CAGM.CUBEAGG_IRID = CAGG.IRID AND CLAP.CUBEAGG_IRID = CAGG.IRID AND CLAP.CUBELOAD_IRID = CL.IRID AND CAGM.MEASURE_IRID = M.IRID AND M.ITEMCONTAINER_IRID = C.IRID AND SCH.IRID = C.DATAMODEL_IRID AND (CWM$UTIL.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) WITH READ ONLY