[Home] [Help]
View: BSC_SYS_DATASETS_VL
Product: | BSC - Balanced Scorecard (Obsolete) |
Description: | View of BSC_SYS_DATASETS_B and BSC_SYS_DATASETS_TL. |
Implementation/DBA Data: |
Not implemented in this database
|
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 |