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
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
|
|
|