eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OLAPSYS.ALL$AW_LOAD_DIM_FILT

Source

View Text - Preformatted


select
    ldm.owner owner,
    ldm.dimension_name dimension_name,
    ldm.load_name load_name,
    lf.lookup_table_owner table_owner,
    lf.lookup_table_name  table_name,
    lf.filtercondition filter_condition
 from olapsys.all$aw_load_dim_map ldm,
      olapsys.cwm2$awdimloadfilter lf
 where ldm.load_irid = lf.dimload_irid
 with read only

View Text - HTML Formatted

SELECT LDM.OWNER OWNER
, LDM.DIMENSION_NAME DIMENSION_NAME
, LDM.LOAD_NAME LOAD_NAME
, LF.LOOKUP_TABLE_OWNER TABLE_OWNER
, LF.LOOKUP_TABLE_NAME TABLE_NAME
, LF.FILTERCONDITION FILTER_CONDITION
FROM OLAPSYS.ALL$AW_LOAD_DIM_MAP LDM
, OLAPSYS.CWM2$AWDIMLOADFILTER LF
WHERE LDM.LOAD_IRID = LF.DIMLOAD_IRID WITH READ ONLY