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_SYS_DATASETS_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_SYS_DATASETS_B and BSC_SYS_DATASETS_TL.
Implementation/DBA Data:	APPS.BSC_SYS_DATASETS_VL

View Text

SELECT B.DATASET_ID
, TL.NAME
, TL.HELP
, B.MEASURE_ID1
, B.OPERATION
, B.MEASURE_ID2
, B.FORMAT_ID
, B.COLOR_METHOD
, B.PROJECTION_FLAG
, NVL(B.EDW_FLAG
, 0) AS EDW_FLAG
, NVL(B.AUTOSCALE_FLAG
, 0) AS AUTOSCALE_FLAG
, TL.Y_AXIS_TITLE
, B.SOURCE
FROM BSC_SYS_DATASETS_TL TL
, BSC_SYS_DATASETS_B B
WHERE B.DATASET_ID = TL.DATASET_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns

Name
DATASET_ID
NAME
HELP
MEASURE_ID1
OPERATION
MEASURE_ID2
FORMAT_ID
COLOR_METHOD
PROJECTION_FLAG
EDW_FLAG
AUTOSCALE_FLAG
Y_AXIS_TITLE
SOURCE