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