View: BSC_DB_MEASURE_BY_DIM_SET_V

Product:	BSC - Balanced Scorecard
Description:	View of measures by dimension set
Implementation/DBA Data:	APPS.BSC_DB_MEASURE_BY_DIM_SET_V

View Text

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

Columns