View of the PMF measures by analysis option for IBUILDER
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT A.INDICATOR , A.ANALYSIS_GROUP_ID AS OPTION_GROUP_ID , A.OPTION_ID , A.NAME AS OPTION_NAME , A.HELP AS DESCRIPTION , BSC_UTILITY.GET_DATASET_ID(A.INDICATOR , A.ANALYSIS_GROUP_ID , A.OPTION_ID) AS DATASET_ID , C.MEASURE_ID1 AS MEASURE_ID , D.SHORT_NAME AS MEAS_SHORT_NAME , D.SOURCE AS MEAS_SOURCE , E.INDICATOR_ID AS PMF_INDICATOR_ID , F.NAME AS PMF_MEAS_NAME , B.DIM_SET_ID AS DIM_SET_ID , BSC_UTILITY.GET_KPI_DIM_LEVELS(A.INDICATOR , B.DIM_SET_ID) AS DIM_LEVELS FROM BSC_KPI_ANALYSIS_OPTIONS_TL A , BSC_KPI_ANALYSIS_OPTIONS_B B , BSC_SYS_DATASETS_B C , BSC_SYS_MEASURES D , BIS_INDICATORS E , BIS_INDICATORS_TL F WHERE A.INDICATOR = B.INDICATOR AND A.ANALYSIS_GROUP_ID = B.ANALYSIS_GROUP_ID AND A.OPTION_ID = B.OPTION_ID AND C.DATASET_ID = BSC_UTILITY.GET_DATASET_ID(A.INDICATOR , A.ANALYSIS_GROUP_ID , A.OPTION_ID) AND D.MEASURE_ID = C.MEASURE_ID1 AND D.SHORT_NAME = E.SHORT_NAME(+) AND E.INDICATOR_ID = F.INDICATOR_ID(+)