VIEW: APPS.BSC_DB_MEASURE_BY_DIM_SET_V

Source

View Text - Preformatted

SELECT DB. INDICATOR, DB.DIM_SET_ID, DS.MEASURE_ID1 AS MEASURE_ID FROM BSC_DB_DATASET_DIM_SETS_V DB, BSC_SYS_DATASETS_VL DS WHERE DB.DATASET_ID = DS.DATASET_ID UNION SELECT DB. INDICATOR, DB.DIM_SET_ID, DS.MEASURE_ID2 AS MEASURE_ID FROM BSC_DB_DATASET_DIM_SETS_V DB, BSC_SYS_DATASETS_VL DS WHERE DB.DATASET_ID = DS.DATASET_ID AND DS.MEASURE_ID2 IS NOT NULL

View Text - HTML Formatted

SELECT DB. INDICATOR
, DB.DIM_SET_ID
, DS.MEASURE_ID1 AS MEASURE_ID
FROM BSC_DB_DATASET_DIM_SETS_V DB
, BSC_SYS_DATASETS_VL DS
WHERE DB.DATASET_ID = DS.DATASET_ID UNION SELECT DB. INDICATOR
, DB.DIM_SET_ID
, DS.MEASURE_ID2 AS MEASURE_ID
FROM BSC_DB_DATASET_DIM_SETS_V DB
, BSC_SYS_DATASETS_VL DS
WHERE DB.DATASET_ID = DS.DATASET_ID
AND DS.MEASURE_ID2 IS NOT NULL