Product: | BSC - Balanced Scorecard (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT F.KPI_ID
, F.FACT_ID
, F.FACT_TABLE
, F.FACT_ALIAS
, F.MEAS_ID
, NULL
, M.MEAS_COL_NAME
, D.DIM_ID
, D.DIM_NAME
, D.DIM_ALIAS
, K.FACT_ATT_ID
, K.FACT_ATT
, D.LOWEST_LEVEL_ATT
, K.HIER_ID
, NULL
, K.LEVEL_ID
, L.CHILD_LVL_NAME
, K.BSC_DIM_LEVEL_ID
, K.LEVEL_ATT
, K.IS_TIME
, K.PERIODICITY_ID
, K.CALENDAR_ID
, NULL
, 'OLAP115'
FROM BSC_EDW_MAP_FACTS F
, BSC_EDW_MAP_DIMS D
, BSC_EDW_MAP_KPI K
, BSC_EDW_MEASURES M
, EDW_LEVEL_RELATIONS_MD_V L
WHERE F.KPI_ID = D.KPI_ID
AND D.KPI_ID = K.KPI_ID
AND K.KPI_ID = M.KPI_ID
AND K.LEVEL_ID = L.CHILD_LVL_ID
AND F.MEAS_ID = D.MEAS_ID
AND D.MEAS_ID = K.MEAS_ID
AND K.MEAS_ID = M.MEAS_ID
AND F.FACT_ID = M.FACT_ID
AND D.DIM_ID = K.DIM_ID