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.

[Home] [Help]

View: BSC_DB_COLOR_KPI_DEFAULTS_V

Product:	BSC - Balanced Scorecard
Description:	View of series id,dimesion set and data set by defaults indicator.
Implementation/DBA Data:	APPS.BSC_DB_COLOR_KPI_DEFAULTS_V

View Text

SELECT M.INDICATOR
, M.SERIES_ID
, DIM_SET_ID
, DATASET_ID FROM BSC_DB_DATASET_DIM_SETS_V M
, BSC_DB_COLOR_AO_DEFAULTS_V D
WHERE M.INDICATOR = D.INDICATOR
AND M.A0 = D.A0_DEFAULT
AND M.A1 = D.A1_DEFAULT
AND M.A2 = D.A2_DEFAULT
AND M.DEFAULT_VALUE= 1

Columns

Name
INDICATOR
SERIES_ID
DIM_SET_ID
DATASET_ID