VIEW: OLAPSYS.ALL$AW_LOAD_CUBE_MEAS

Source

View Text - Preformatted

select
  lcm.owner owner,
  lcm.cube_name cube_name,
  lcm.load_name load_name,
  m.name measure_name,
  clm.name measure_target_name,
  clm.displayname measure_target_display_name,
  clm.description measure_target_description
 from
   olapsys.all$aw_load_cube_map lcm,
   olapsys.cwm2$measure m,
   olapsys.cwm2$awcubeloadmeasure clm
 where
   lcm.cube_irid = m.cube_irid and
   lcm.load_irid = clm.cubeload_irid and
   m.irid = clm.measure_irid and
   lcm.version_id = 'CWM2'
union all
 select
  lcm.owner owner,
  lcm.cube_name cube_name,
  lcm.load_name load_name,
  m.name measure_name,
  clm.name measure_target_name,
  clm.displayname measure_display_name,
  clm.description measure_target_description
 from
   olapsys.all$aw_load_cube_map lcm,
   olapsys.cwm$measure m,
   olapsys.cwm2$awcubeloadmeasure clm
 where
   lcm.cube_irid = m.itemcontainer_irid and
   lcm.load_irid = clm.cubeload_irid and
   m.irid = clm.measure_irid and
   lcm.version_id = 'CWM'
with read only

View Text - HTML Formatted

SELECT LCM.OWNER OWNER
, LCM.CUBE_NAME CUBE_NAME
, LCM.LOAD_NAME LOAD_NAME
, M.NAME MEASURE_NAME
, CLM.NAME MEASURE_TARGET_NAME
, CLM.DISPLAYNAME MEASURE_TARGET_DISPLAY_NAME
, CLM.DESCRIPTION MEASURE_TARGET_DESCRIPTION FROM OLAPSYS.ALL$AW_LOAD_CUBE_MAP LCM
, OLAPSYS.CWM2$MEASURE M
, OLAPSYS.CWM2$AWCUBELOADMEASURE CLM WHERE LCM.CUBE_IRID = M.CUBE_IRID AND LCM.LOAD_IRID = CLM.CUBELOAD_IRID AND M.IRID = CLM.MEASURE_IRID AND LCM.VERSION_ID = 'CWM2' UNION ALL SELECT LCM.OWNER OWNER
, LCM.CUBE_NAME CUBE_NAME
, LCM.LOAD_NAME LOAD_NAME
, M.NAME MEASURE_NAME
, CLM.NAME MEASURE_TARGET_NAME
, CLM.DISPLAYNAME MEASURE_DISPLAY_NAME
, CLM.DESCRIPTION MEASURE_TARGET_DESCRIPTION FROM OLAPSYS.ALL$AW_LOAD_CUBE_MAP LCM
, OLAPSYS.CWM$MEASURE M
, OLAPSYS.CWM2$AWCUBELOADMEASURE CLM WHERE LCM.CUBE_IRID = M.ITEMCONTAINER_IRID AND LCM.LOAD_IRID = CLM.CUBELOAD_IRID AND M.IRID = CLM.MEASURE_IRID AND LCM.VERSION_ID = 'CWM' WITH READ ONLY