[Home] [Help]
View: BSC_KPI_DATA_TABLES_V
Product: | BSC - Balanced Scorecard (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT T.INDICATOR
, T.PERIODICITY_ID
, T.DIM_SET_ID
, T.LEVEL_COMB
, DECODE(K.EDW_FLAG
, 1
, SUBSTR(T.TABLE_NAME
, 1
, LENGTH(T.TABLE_NAME)-2)
, T.TABLE_NAME) AS TABLE_NAME
, T.FILTER_CONDITION
FROM BSC_KPI_DATA_TABLES T
, BSC_KPIS_B K
WHERE T.INDICATOR = K.INDICATOR
Columns
Name |
INDICATOR |
PERIODICITY_ID |
DIM_SET_ID |
LEVEL_COMB |
TABLE_NAME |
FILTER_CONDITION |