VIEW: OLAPSYS.ALL$AW_LOAD_DIM_PARM

Source

View Text - Preformatted

select
    ldm.owner owner,
    ldm.dimension_name dimension_name,
    ldm.load_name load_name,
    dlp.name parm_name,
    dlpv.value parm_value
 from olapsys.all$aw_load_dim_map ldm,
      olapsys.cwm2$awdimloadparm dlp,
      olapsys.cwm2$awdimloadparmvalue dlpv
 where ldm.load_irid = dlpv.dimload_irid
   and dlpv.parmname_irid = dlp.irid
with read only

View Text - HTML Formatted

SELECT LDM.OWNER OWNER
, LDM.DIMENSION_NAME DIMENSION_NAME
, LDM.LOAD_NAME LOAD_NAME
, DLP.NAME PARM_NAME
, DLPV.VALUE PARM_VALUE
FROM OLAPSYS.ALL$AW_LOAD_DIM_MAP LDM
, OLAPSYS.CWM2$AWDIMLOADPARM DLP
, OLAPSYS.CWM2$AWDIMLOADPARMVALUE DLPV
WHERE LDM.LOAD_IRID = DLPV.DIMLOAD_IRID
AND DLPV.PARMNAME_IRID = DLP.IRID WITH READ ONLY