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: APPS.BSC_DB_DATASET_DIM_SETS_V

Source

View Text - Preformatted


SELECT DISTINCT 
DATA.INDICATOR, 
DATA.ANALYSIS_OPTION0 AS A0, 
DATA.ANALYSIS_OPTION1 AS A1, 
DATA.ANALYSIS_OPTION2 AS A2, 
DATA.SERIES_ID AS SERIES_ID, 
NVL(BASIC.DIM_SET_ID,0) AS DIM_SET_ID, 
DATA.DATASET_ID, 
DATA.DEFAULT_VALUE AS DEFAULT_VALUE, 
DATA.KPI_MEASURE_ID 
FROM 
BSC_DB_BASIC_DIM_SETS_V BASIC, 
BSC_KPI_ANALYSIS_MEASURES_VL DATA 
WHERE 
DATA.INDICATOR = BASIC.INDICATOR (+) 
AND DATA.ANALYSIS_OPTION0 = BASIC.A0 (+) 
AND DATA.ANALYSIS_OPTION1 = BASIC.A1 (+) 
AND DATA.ANALYSIS_OPTION2 = BASIC.A2 (+)

View Text - HTML Formatted

SELECT DISTINCT DATA.INDICATOR
, DATA.ANALYSIS_OPTION0 AS A0
, DATA.ANALYSIS_OPTION1 AS A1
, DATA.ANALYSIS_OPTION2 AS A2
, DATA.SERIES_ID AS SERIES_ID
, NVL(BASIC.DIM_SET_ID
, 0) AS DIM_SET_ID
, DATA.DATASET_ID
, DATA.DEFAULT_VALUE AS DEFAULT_VALUE
, DATA.KPI_MEASURE_ID FROM BSC_DB_BASIC_DIM_SETS_V BASIC
, BSC_KPI_ANALYSIS_MEASURES_VL DATA WHERE DATA.INDICATOR = BASIC.INDICATOR (+) AND DATA.ANALYSIS_OPTION0 = BASIC.A0 (+) AND DATA.ANALYSIS_OPTION1 = BASIC.A1 (+) AND DATA.ANALYSIS_OPTION2 = BASIC.A2 (+)