[Home] [Help]
2902: SELECT MEASURE_COL, HELP, MEASURE_GROUP_ID, PROJECTION_ID, NVL(MEASURE_TYPE, 1) MTYPE
2903: FROM BSC_DB_MEASURE_COLS_VL
2904: WHERE MEASURE_COL NOT IN
2905: (
2906: SELECT MEASURE_COL FROM BSC_SYS_MEASURES M
2907: WHERE NVL(M.SOURCE, 'BSC') = 'PMF'
2908: and not exists( select 1 from BSC_SYS_MEASURES P where p.Measure_Col = m.measure_col
2909: and NVL(p.SOURCE, 'BSC') = 'BSC')
2910: ) ORDER BY MEASURE_COL;*/
2904: WHERE MEASURE_COL NOT IN
2905: (
2906: SELECT MEASURE_COL FROM BSC_SYS_MEASURES M
2907: WHERE NVL(M.SOURCE, 'BSC') = 'PMF'
2908: and not exists( select 1 from BSC_SYS_MEASURES P where p.Measure_Col = m.measure_col
2909: and NVL(p.SOURCE, 'BSC') = 'BSC')
2910: ) ORDER BY MEASURE_COL;*/
2911: --BSC autogen
2912:
2912:
2913: CURSOR c1 IS
2914: SELECT DB.MEASURE_COL, DB.HELP, DB.MEASURE_GROUP_ID, DB.PROJECTION_ID, NVL(DB.MEASURE_TYPE, 1) MTYPE, M.SOURCE
2915: FROM BSC_DB_MEASURE_COLS_VL DB,
2916: BSC_SYS_MEASURES M
2917: WHERE db.Measure_Col = m.measure_col
2918: AND M.SOURCE = 'BSC'
2919: UNION
2920: SELECT M.MEASURE_COL, null HELP, -1 MEASURE_GROUP_ID, 0 PROJECTION_ID, 1 MTYPE, M.SOURCE
2917: WHERE db.Measure_Col = m.measure_col
2918: AND M.SOURCE = 'BSC'
2919: UNION
2920: SELECT M.MEASURE_COL, null HELP, -1 MEASURE_GROUP_ID, 0 PROJECTION_ID, 1 MTYPE, M.SOURCE
2921: FROM BSC_SYS_MEASURES M
2922: WHERE M.SOURCE='PMF'
2923: ORDER BY MEASURE_COL;
2924:
2925: cRow c1%ROWTYPE;
3458: i:=i+1;
3459: END LOOP;*/
3460:
3461: Add_value_BULK(9, BSC_METADATA_OPTIMIZER_PKG.garrIndics4);
3462: l_stmt := 'SELECT DISTINCT M.MEASURE_COL, M.SOURCE, M.MEASURE_ID FROM BSC_SYS_MEASURES M, '||
3463: BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I
3464: WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereInIndics ||' )
3465: AND M.TYPE = 0';
3466: OPEN cv FOR l_stmt;
3483: For that reason the indicators were flaged to 4
3484: We need to see in all system measures if there is a formula using that measure.
3485: IF that happen we need to add that measure. Any kpi using that meaure should be flaged too.*/
3486: strWhereNotInIndics := ' NOT ( ' || strWhereInIndics || ')';
3487: l_stmt := 'SELECT DISTINCT M.MEASURE_ID, M.MEASURE_COL FROM BSC_SYS_MEASURES M, '
3488: ||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||
3489: ' I WHERE I.MEASURE_ID = M.MEASURE_ID
3490: AND ('|| strWhereNotInIndics ||' )
3491: AND M.TYPE = 0 ';