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_CLEVEL3_V

Product:	BSC - Balanced Scorecard
Description:	View of color level 3 by color method.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT KP.INDICATOR
, NVL(CM1.PROPERTY_VALUE
, 0) AS COL_M1_LEVEL3
, NVL(CM2.PROPERTY_VALUE
, 0) AS COL_M2_LEVEL3
, NVL(CM3.PROPERTY_VALUE
, 95) AS COL_M3_LEVEL3 FROM BSC_TAB_INDICATORS KP
, BSC_KPI_PROPERTIES CM1
, BSC_KPI_PROPERTIES CM2
, BSC_KPI_PROPERTIES CM3
WHERE KP.INDICATOR =CM1.INDICATOR(+)
AND CM1.PROPERTY_CODE(+) ='COL_M1_LEVEL3'
AND KP.INDICATOR =CM2.INDICATOR(+)
AND CM2.PROPERTY_CODE(+) ='COL_M2_LEVEL3'
AND KP.INDICATOR =CM3.INDICATOR(+)
AND CM3.PROPERTY_CODE(+) ='COL_M3_LEVEL3'

Columns

Name
INDICATOR
COL_M1_LEVEL3
COL_M2_LEVEL3
COL_M3_LEVEL3