DBA Data[Home] [Help]

VIEW: OLAPSYS.ALL$AW_LOAD_CUBE_PARM

Source

View Text - Preformatted

select
   lcm.owner owner,
   lcm.cube_name cube_name,
   lcm.load_name load_name,
   clp.name parm_name,
   clpv.value parm_value
 from olapsys.all$aw_load_cube_map lcm,
      olapsys.cwm2$awcubeloadparm clp,
      olapsys.cwm2$awcubeloadparmvalue clpv
 where lcm.load_irid = clpv.cubeload_irid
   and clpv.parmname_irid = clp.irid
with read only
View Text - HTML Formatted

SELECT LCM.OWNER OWNER
, LCM.CUBE_NAME CUBE_NAME
, LCM.LOAD_NAME LOAD_NAME
, CLP.NAME PARM_NAME
, CLPV.VALUE PARM_VALUE
FROM OLAPSYS.ALL$AW_LOAD_CUBE_MAP LCM
, OLAPSYS.CWM2$AWCUBELOADPARM CLP
, OLAPSYS.CWM2$AWCUBELOADPARMVALUE CLPV
WHERE LCM.LOAD_IRID = CLPV.CUBELOAD_IRID
AND CLPV.PARMNAME_IRID = CLP.IRID WITH READ ONLY