eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DBGEN_BSC_READER dependencies on BSC_DBGEN_UTILS

Line 167: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, to_char(cRow.PROJECTION_ID));

163: --2: Plan-Based (not used any more)
164: --3: Plan-Based
165: --4: Custom
166: IF (cRow.PROJECTION_ID IS NOT NULL) THEN
167: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, to_char(cRow.PROJECTION_ID));
168: Else
169: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, 0);--no projection
170: END IF;
171: l_measure.measure_type := cRow.MTYPE;

Line 169: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, 0);--no projection

165: --4: Custom
166: IF (cRow.PROJECTION_ID IS NOT NULL) THEN
167: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, to_char(cRow.PROJECTION_ID));
168: Else
169: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, 0);--no projection
170: END IF;
171: l_measure.measure_type := cRow.MTYPE;
172: g_sys_measures(g_sys_measures.count+1) := l_measure;
173: END Loop;

Line 585: Measures := BSC_DBGEN_UTILS.get_measure_list(l_measure_name);

581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;
582: LOOP
583: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_id, l_measure_type, l_measure_source;
584: EXIT WHEN cv%NOTFOUND;
585: Measures := BSC_DBGEN_UTILS.get_measure_list(l_measure_name);
586: l_num_measures := Measures.count;
587: i := Measures.first;
588: LOOP
589: EXIT WHEN Measures.count = 0;

Line 606: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);

602: l_measure.measure_type := l_measure_type;
603: l_measure.AGGREGATION_method := FuncAgregSingleColumn;
604: l_measure.datatype := 'NUMBER';
605: l_measure.measure_source := l_measure_source;
606: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);
607: If pAvgLSingleColumn = 'Y' Then
608: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
609: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
610: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, AvgLTotalColumn||'/'||AvgLCounterColumn);

Line 608: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);

604: l_measure.datatype := 'NUMBER';
605: l_measure.measure_source := l_measure_source;
606: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);
607: If pAvgLSingleColumn = 'Y' Then
608: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
609: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
610: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, AvgLTotalColumn||'/'||AvgLCounterColumn);
611: END IF;
612: END IF;

Line 609: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);

605: l_measure.measure_source := l_measure_source;
606: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);
607: If pAvgLSingleColumn = 'Y' Then
608: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
609: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
610: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, AvgLTotalColumn||'/'||AvgLCounterColumn);
611: END IF;
612: END IF;
613: EXIT WHEN i = Measures.last;

Line 610: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, AvgLTotalColumn||'/'||AvgLCounterColumn);

606: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);
607: If pAvgLSingleColumn = 'Y' Then
608: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
609: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
610: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, AvgLTotalColumn||'/'||AvgLCounterColumn);
611: END IF;
612: END IF;
613: EXIT WHEN i = Measures.last;
614: i := Measures.next(i);

Line 909: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(10, 'INDICATOR');

905: (SELECT to_number(fact_name) FROM BSC_DB_GEN_KPI_LIST WHERE process_id = :process_ID)';
906: l_Stmt := l_stmt || ' ORDER BY INDICATOR ';
907: OPEN cv FOR l_stmt using p_prototype_flag, p_process_id;
908: ELSE
909: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(10, 'INDICATOR');
910: IF (l_fact_list.count>0) THEN
911: FOR i IN l_fact_list.first..l_fact_list.last LOOP
912: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, p_fact_list(i));
913: END LOOP;

Line 912: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, p_fact_list(i));

908: ELSE
909: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(10, 'INDICATOR');
910: IF (l_fact_list.count>0) THEN
911: FOR i IN l_fact_list.first..l_fact_list.last LOOP
912: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, p_fact_list(i));
913: END LOOP;
914: END IF;
915: l_stmt := l_stmt || ' where '||strWhereInIndics;
916: l_Stmt := l_stmt || ' ORDER BY INDICATOR ';

Line 923: l_optimizationMode := BSC_DBGEN_UTILS.get_KPI_Property_Value(l_Code, 'DB_TRANSFORM', 1);

919: LOOP
920: FETCH cv into l_code, l_name, l_action_flag,
921: l_IndicatorType, l_configType, l_per_inter, l_share_flag, l_source_indicator;
922: EXIT WHEN cv%NOTFOUND;
923: l_optimizationMode := BSC_DBGEN_UTILS.get_KPI_Property_Value(l_Code, 'DB_TRANSFORM', 1);
924: IF l_Action_Flag <> 2 THEN
925: l_Action_Flag := 3;
926: END IF;
927: l_fact.Fact_ID := l_code;

Line 931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);

927: l_fact.Fact_ID := l_code;
928: l_fact.Fact_Name := l_name;
929: l_fact.fact_type := l_indicatorType;
930: l_fact.Application_short_name := 'BSC';
931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);
932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);

Line 932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);

928: l_fact.Fact_Name := l_name;
929: l_fact.fact_type := l_indicatorType;
930: l_fact.Application_short_name := 'BSC';
931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);
932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);
936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));

Line 933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);

929: l_fact.fact_type := l_indicatorType;
930: l_fact.Application_short_name := 'BSC';
931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);
932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);
936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));
937: l_fact_list(l_fact_list.count+1) := l_fact;

Line 934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);

930: l_fact.Application_short_name := 'BSC';
931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);
932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);
936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));
937: l_fact_list(l_fact_list.count+1) := l_fact;
938: END Loop;

Line 935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);

931: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PROTOTYPE_FLAG, l_action_flag);
932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);
936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));
937: l_fact_list(l_fact_list.count+1) := l_fact;
938: END Loop;
939: CLOSE cv;

Line 936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));

932: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.CONFIG_TYPE, l_ConfigType);
933: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.PERIODICITY_ID, l_per_inter);
934: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.OPTIMIZATION_MODE, l_OptimizationMode);
935: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SHARE_FLAG,l_share_flag);
936: bsc_dbgen_utils.add_property(l_fact.properties, BSC_DBGEN_STD_METADATA.SOURCE_INDICATOR, nvl(l_source_indicator, 0));
937: l_fact_list(l_fact_list.count+1) := l_fact;
938: END Loop;
939: CLOSE cv;
940: EXCEPTION WHEN OTHERS THEN

Line 993: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(9, 'I.INDICATOR');

989: END IF;
990: --Init and array with the measures used by the indicators flagged for
991: --non-structural changes
992: l_num_measures := 0;
993: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(9, 'I.INDICATOR');
994: i:= 0;
995: LOOP
996: EXIT WHEN i=l_fact_list.count;
997: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, l_fact_list(i).fact_id);

Line 997: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, l_fact_list(i).fact_id);

993: strWhereInIndics := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number(9, 'I.INDICATOR');
994: i:= 0;
995: LOOP
996: EXIT WHEN i=l_fact_list.count;
997: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, l_fact_list(i).fact_id);
998: i:=i+1;
999: END LOOP;
1000: --PMF-BSC Integration: Filter out PMF measures
1001: l_stmt := 'SELECT DISTINCT M.MEASURE_COL FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I'

Line 1041: strWhereInMeasures := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number( 9, 'MEASURE_ID');

1037: CLOSE cv;
1038: --Now we need to add to the indicator list all the indicators using any of the measures
1039: --in arrRelatedMeasuresIds()
1040: IF arrRelatedMeasuresIds.count > 0 THEN
1041: strWhereInMeasures := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number( 9, 'MEASURE_ID');
1042: i:= arrRelatedMeasuresIds.first;
1043: LOOP
1044: EXIT WHEN i=arrRelatedMeasuresIds.last;
1045: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, arrRelatedMeasuresIds(i));

Line 1045: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, arrRelatedMeasuresIds(i));

1041: strWhereInMeasures := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number( 9, 'MEASURE_ID');
1042: i:= arrRelatedMeasuresIds.first;
1043: LOOP
1044: EXIT WHEN i=arrRelatedMeasuresIds.last;
1045: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, arrRelatedMeasuresIds(i));
1046: i:= arrRelatedMeasuresIds.next(i);
1047: END LOOP;
1048: l_stmt := 'SELECT DISTINCT INDICATOR FROM BSC_DB_MEASURE_BY_DIM_SET_V '||
1049: ' WHERE ('|| strWhereInMeasures || ')';

Line 1202: Measures := BSC_DBGEN_UTILS.get_measure_list(l_measure_name);

1198:
1199: LOOP
1200: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_source ;
1201: EXIT WHEN cv%NOTFOUND;
1202: Measures := BSC_DBGEN_UTILS.get_measure_list(l_measure_name);
1203: l_num_measures := Measures.count;
1204: i := Measures.first;
1205: LOOP
1206: EXIT WHEN Measures.count = 0;

Line 1223: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);

1219: l_measure.AGGREGATION_method := FuncAgregSingleColumn;
1220: l_measure.datatype := 'NUMBER';
1221: l_measure.measure_source := l_measure_source;
1222: --l_measure.Origen is not set
1223: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_SINGLE_COLUMN, pAvgLSingleColumn);
1224: If pAvgLSingleColumn = 'Y' Then
1225: --This is a single column, we can have AvgL on a single column.
1226: --We need two internal columns: one for total and one for counter
1227: --Also we need to add the internal columns in gLov and in

Line 1235: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);

1231: AvgLTotalColumn := get_Next_Internal_Column_Name;
1232: --Update the measure property pAvgLTotal in the database
1233: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, AvgLTotalColumn);
1234: END IF;
1235: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
1236: --AddInternalColumnInDB(AvgLTotalColumn, 2, baseColumn, 1);
1237: If AvgLCounterColumn IS NULL Then
1238: AvgLCounterColumn := get_Next_Internal_Column_Name;
1239: --Update the measure property pAvgLCounter in the database

Line 1242: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);

1238: AvgLCounterColumn := get_Next_Internal_Column_Name;
1239: --Update the measure property pAvgLCounter in the database
1240: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, AvgLCounterColumn);
1241: END IF;
1242: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
1243: --AddInternalColumnInDB(AvgLCounterColumn, 3, baseColumn, 1);
1244: END IF;
1245: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 0); -- Normal
1246: colMeasures(colMeasures.count+1) := l_measure;

Line 1245: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 0); -- Normal

1241: END IF;
1242: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
1243: --AddInternalColumnInDB(AvgLCounterColumn, 3, baseColumn, 1);
1244: END IF;
1245: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 0); -- Normal
1246: colMeasures(colMeasures.count+1) := l_measure;
1247:
1248: If pAvgLSingleColumn = 'Y' Then
1249: --Add the two internal column for AvgL in the collection

Line 1256: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');

1252: l_measure.measure_name := AvgLTotalColumn;
1253: l_measure.aggregation_method := 'SUM';
1254: l_measure.datatype := 'NUMBER';
1255: --l_measure.Origen is not set
1256: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1257: --l_measure.avgLTotalColumn does not apply
1258: --l_measure.avgLCounterColumn does not apply
1259:
1260: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); --Internal column for Total of AvgL

Line 1260: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); --Internal column for Total of AvgL

1256: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1257: --l_measure.avgLTotalColumn does not apply
1258: --l_measure.avgLCounterColumn does not apply
1259:
1260: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); --Internal column for Total of AvgL
1261: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));
1262: colMeasures(colMeasures.count+1) := l_measure;
1263: --Column for Counter
1264: l_measure := l_measure_null;

Line 1261: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));

1257: --l_measure.avgLTotalColumn does not apply
1258: --l_measure.avgLCounterColumn does not apply
1259:
1260: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); --Internal column for Total of AvgL
1261: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));
1262: colMeasures(colMeasures.count+1) := l_measure;
1263: --Column for Counter
1264: l_measure := l_measure_null;
1265: l_measure.measure_Name := AvgLCounterColumn;

Line 1269: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');

1265: l_measure.measure_Name := AvgLCounterColumn;
1266: l_measure.AGGREGATION_method := 'SUM';
1267: l_measure.datatype := 'NUMBER';
1268: --l_measure.Origen is not set
1269: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1270: --l_measure.avgLTotalColumn does not apply
1271: --l_measure.avgLCounterColumn does not apply
1272: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1273: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));

Line 1272: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL

1268: --l_measure.Origen is not set
1269: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1270: --l_measure.avgLTotalColumn does not apply
1271: --l_measure.avgLCounterColumn does not apply
1272: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1273: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));
1274: colMeasures(colMeasures.count+1) := l_measure;
1275: END IF;
1276: END IF;

Line 1273: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));

1269: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1270: --l_measure.avgLTotalColumn does not apply
1271: --l_measure.avgLCounterColumn does not apply
1272: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1273: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, Measures(i));
1274: colMeasures(colMeasures.count+1) := l_measure;
1275: END IF;
1276: END IF;
1277:

Line 1295: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, pAvgL);

1291: l_measure.measure_Name := pFormulaSource;
1292: l_measure.aggregation_method := l_aggregation_method;
1293: l_measure.datatype := 'NUMBER';
1294: --l_measure.Origen is not set
1295: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, pAvgL);
1296: If pAvgL = 'Y' Then
1297: --This is a formula calculated in another column, we can have AvgL on a that.
1298: --We need to internal columns: one for total and one for counter
1299: --Also we need to add the internal columns in gLov and in

Line 1307: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, pAvgLTotal);

1303: --Update the measure property pAvgLTotal in the database
1304: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, pAvgLTotal);
1305: END IF;
1306: --AddInternalColumnInDB(pAvgLTotal, 2, Measures, l_num_measures);
1307: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, pAvgLTotal);
1308: If pAvgLCounter IS NULL Then
1309: pAvgLCounter := get_Next_Internal_Column_Name;
1310: --Update the measure property pAvgLTotal in the database
1311: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, pAvgLCounter);

Line 1314: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, pAvgLCounter);

1310: --Update the measure property pAvgLTotal in the database
1311: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, pAvgLCounter);
1312: END IF;
1313: --AddInternalColumnInDB( pAvgLCounter, 3, Measures, l_num_measures);
1314: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, pAvgLCounter);
1315: END IF;
1316: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 1); --Internal column for formula
1317: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/
1318: colMeasures(colMeasures.last +1 ) := l_measure;

Line 1316: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 1); --Internal column for formula

1312: END IF;
1313: --AddInternalColumnInDB( pAvgLCounter, 3, Measures, l_num_measures);
1314: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, pAvgLCounter);
1315: END IF;
1316: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 1); --Internal column for formula
1317: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/
1318: colMeasures(colMeasures.last +1 ) := l_measure;
1319: If pAvgL = 'Y' Then
1320: --Add the two internal column for AvgL in the collection

Line 1317: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/

1313: --AddInternalColumnInDB( pAvgLCounter, 3, Measures, l_num_measures);
1314: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, pAvgLCounter);
1315: END IF;
1316: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 1); --Internal column for formula
1317: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/
1318: colMeasures(colMeasures.last +1 ) := l_measure;
1319: If pAvgL = 'Y' Then
1320: --Add the two internal column for AvgL in the collection
1321: --Bug 2993089: When the column is not a formula but has the option

Line 1333: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');

1329: l_measure.measure_Name := pAvgLTotal;
1330: l_measure.AGGREGATION_method := 'SUM';
1331: l_measure.datatype := 'NUMBER';
1332: --l_measure.Origen is not set
1333: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1334: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); -- 'Internal column for Total of AvgL
1335: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B
1336: colMeasures(colMeasures.last+1) := l_measure ;
1337: END IF;

Line 1334: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); -- 'Internal column for Total of AvgL

1330: l_measure.AGGREGATION_method := 'SUM';
1331: l_measure.datatype := 'NUMBER';
1332: --l_measure.Origen is not set
1333: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1334: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); -- 'Internal column for Total of AvgL
1335: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B
1336: colMeasures(colMeasures.last+1) := l_measure ;
1337: END IF;
1338: --Column for Counter

Line 1335: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B

1331: l_measure.datatype := 'NUMBER';
1332: --l_measure.Origen is not set
1333: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1334: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 2); -- 'Internal column for Total of AvgL
1335: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B
1336: colMeasures(colMeasures.last+1) := l_measure ;
1337: END IF;
1338: --Column for Counter
1339: If Not measure_exists(colMeasures, pAvgLCounter, 'BSC') Then

Line 1345: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');

1341: l_measure.measure_name := pAvgLCounter;
1342: l_measure.AGGREGATION_METHOD := 'SUM';
1343: l_measure.datatype := 'NUMBER';
1344: --l_measure.Origen is not set
1345: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1346: --l_measure.avgLTotalColumn does not apply
1347: --l_measure.avgLCounterColumn does not apply
1348: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1349: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B

Line 1348: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL

1344: --l_measure.Origen is not set
1345: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1346: --l_measure.avgLTotalColumn does not apply
1347: --l_measure.avgLCounterColumn does not apply
1348: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1349: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B
1350: colMeasures(colMeasures.last+1) := l_measure ;
1351: END IF;
1352: END IF;

Line 1349: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B

1345: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_FLAG, 'N');
1346: --l_measure.avgLTotalColumn does not apply
1347: --l_measure.avgLCounterColumn does not apply
1348: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_TYPE, 3); --Internal column for Counter of AvgL
1349: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.INTERNAL_COLUMN_SOURCE, l_measure_name); -- Formula Example A/B
1350: colMeasures(colMeasures.last+1) := l_measure ;
1351: END IF;
1352: END IF;
1353: END IF;

Line 1395: l_measures_list := BSC_DBGEN_UTILS.get_measure_list(i.measure_col);

1391: END IF;
1392: --BSC-PMF Integration: Even though a PMF measure cannot be present in a BSC
1393: --dimension set, I am going to do the validation to filter out PMF measures
1394: FOR i IN cMeasureList LOOP
1395: l_measures_list := BSC_DBGEN_UTILS.get_measure_list(i.measure_col);
1396: l_num_measures := l_measures_list.count;
1397: IF (l_measures_list.count>0) THEN
1398: FOR j IN l_measures_list.first..l_measures_list.last LOOP
1399: If Not measure_exists(colMeasures, l_measures_list(j), i.measure_source) Then

Line 1415: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, l_measure_row.projection_id);

1411: --1: Statistic
1412: --2: Balance
1413: l_measure.Measure_Type := l_measure_row.measure_type;
1414: l_measure.measure_group := l_measure_row.measure_group_id;
1415: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, l_measure_row.projection_id);
1416: colMeasures(colMeasures.count+1) := l_measure;
1417: END IF;
1418: END LOOP;
1419: END IF;

Line 1456: bsc_dbgen_utils.add_property(l_periodicity.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, cRow.target_level);

1452: FETCH cPeriodicities INTO cRow;
1453: EXIT WHEN cPeriodicities%NOTFOUND;
1454: l_periodicity.periodicity_id := cRow.periodicity_id;
1455: l_periodicity.calendar_id := cRow.calendar_id;
1456: bsc_dbgen_utils.add_property(l_periodicity.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, cRow.target_level);
1457: colPeriodicities(colPeriodicities.count+1) := l_periodicity;
1458: END LOOP;
1459: close cPeriodicities;
1460: colPeriodicities := configure_parent_periods(colPeriodicities);

Line 1545: bsc_dbgen_utils.add_property(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, TargetLevel);

1541: cLevel.level_pk := l_level_pk;
1542: cLevel.level_table_name := l_level_table;
1543: cLevel.level_Name := l_level_table;
1544: cLevel.level_fk := l_level_Fk;
1545: bsc_dbgen_utils.add_property(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, TargetLevel);
1546: l_dimension_index := get_dimension_index(l_dimensions, l_level_table, p_include_missing_levels, l_missing_levels);
1547: --Get the index of the drill family which this drill belongs to.
1548: If l_dimension_index <> -1 Then
1549: --Level belongs to family l_dimension_index.

Line 1560: bsc_dbgen_utils.add_property(l_missing_level.properties, BSC_DBGEN_STD_METADATA.MISSING_LEVEL, 'Y');

1556: l_missing_level := level_null;
1557: l_missing_level.level_pk := l_missing_level_info.level_pk_col;
1558: l_missing_level.level_table_name := l_missing_levels(i);
1559: l_missing_level.level_name := l_missing_levels(i);
1560: bsc_dbgen_utils.add_property(l_missing_level.properties, BSC_DBGEN_STD_METADATA.MISSING_LEVEL, 'Y');
1561: l_current_level_index := l_current_level_index + 1;
1562: l_missing_level.level_index := l_current_level_index ;
1563: l_dimensions(l_dimensions.count).Hierarchies(1).Levels(l_current_level_index) := l_missing_level;
1564: END LOOP;

Line 1571: IF bsc_dbgen_utils.get_property_value(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL) = '1' Then

1567: END IF;
1568: -- needed to handle missing levels
1569: cLevel.level_index := l_current_level_index;
1570: --Review target levels
1571: IF bsc_dbgen_utils.get_property_value(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL) = '1' Then
1572: --If target apply to this level, then
1573: --it must apply for all parents
1574: IF l_dimensions(l_dimension_index).Hierarchies(1).Levels.count>0 THEN
1575: FOR j IN l_dimensions(l_dimension_index).Hierarchies(1).Levels.first..l_dimensions(l_dimension_index).Hierarchies(1).Levels.last LOOP

Line 1576: bsc_dbgen_utils.add_property(l_dimensions(l_dimension_index).Hierarchies(1).Levels(j).properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, 1);

1572: --If target apply to this level, then
1573: --it must apply for all parents
1574: IF l_dimensions(l_dimension_index).Hierarchies(1).Levels.count>0 THEN
1575: FOR j IN l_dimensions(l_dimension_index).Hierarchies(1).Levels.first..l_dimensions(l_dimension_index).Hierarchies(1).Levels.last LOOP
1576: bsc_dbgen_utils.add_property(l_dimensions(l_dimension_index).Hierarchies(1).Levels(j).properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, 1);
1577: END LOOP;
1578: END IF;
1579: END IF;
1580: -- set parent levels

Line 1608: bsc_dbgen_utils.add_property(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, 1);

1604: --Review target level
1605: --This is the first Level in this family, then target must apply
1606: l_current_level_index := 1;
1607: cLevel.level_index := l_current_level_index;
1608: bsc_dbgen_utils.add_property(cLevel.properties, BSC_DBGEN_STD_METADATA.TARGET_LEVEL, 1);
1609: l_dimensions(l_dimensions.count+1).Hierarchies(1).Levels(1) := cLevel;
1610: END IF;
1611: END Loop;
1612: close cv;

Line 1713: l_level.Level_PK_Datatype := BSC_DBGEN_UTILS.get_datatype(p_level, l_level.Level_PK);

1709: OPEN c_level;
1710: FETCH c_level INTO l_level.Level_id, l_level.level_fk;
1711: CLOSE c_level;
1712: l_level.Level_PK := 'CODE';
1713: l_level.Level_PK_Datatype := BSC_DBGEN_UTILS.get_datatype(p_level, l_level.Level_PK);
1714: l_level.level_type := 0; -- normal
1715: return l_level;
1716: Exception when others then
1717: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Level_Info:level='||p_level||', error='||sqlerrm);

Line 1733: l_stmt := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2(1, 'level_table_name');

1729: IF (p_levels.count=0) THEN
1730: return l_facts;
1731: END IF;
1732: init;
1733: l_stmt := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2(1, 'level_table_name');
1734: For i IN p_levels.first..p_levels.last LOOP
1735: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2 (1, p_levels(i));
1736: END LOOP;
1737: --insert the children

Line 1735: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2 (1, p_levels(i));

1731: END IF;
1732: init;
1733: l_stmt := BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2(1, 'level_table_name');
1734: For i IN p_levels.first..p_levels.last LOOP
1735: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2 (1, p_levels(i));
1736: END LOOP;
1737: --insert the children
1738: l_stmt := 'SELECT distinct dim.INDICATOR, dim.DIM_SET_ID, kpi.name , ''BSC''
1739: FROM BSC_KPI_DIM_LEVELS_B dim, BSC_KPIS_VL kpi

Line 1843: l_level.level_pk_datatype := BSC_DBGEN_UTILS.get_datatype(l_level.level_table_name, l_level.level_pk);

1839: l_level.level_name := i.level_table_name;
1840: l_level.level_table_name := i.level_table_name;
1841: l_level.level_fk := i.level_pk_col;
1842: l_level.level_pk := 'CODE';
1843: l_level.level_pk_datatype := BSC_DBGEN_UTILS.get_datatype(l_level.level_table_name, l_level.level_pk);
1844: l_level_list(l_level_list.count+1) := l_level;
1845: END LOOP;
1846: return l_level_list;
1847: Exception when others then

Line 1981: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);

1977: -- just get the operator
1978: l_measure.aggregation_method := substr(i.source_formula, 1, instr(i.source_formula, '(')-1);
1979: l_measure.datatype := 'NUMBER';
1980: l_measure.measure_group := i.measure_group_id;
1981: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);
1982: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);
1983: l_measure_list(l_measure_list.count+1) := l_measure;
1984: END LOOP;
1985: ELSE

Line 1982: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);

1978: l_measure.aggregation_method := substr(i.source_formula, 1, instr(i.source_formula, '(')-1);
1979: l_measure.datatype := 'NUMBER';
1980: l_measure.measure_group := i.measure_group_id;
1981: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);
1982: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);
1983: l_measure_list(l_measure_list.count+1) := l_measure;
1984: END LOOP;
1985: ELSE
1986: FOR i IN cMeasuresIncludeDerived(l_lowest_s_table) LOOP

Line 1994: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);

1990: -- just get the operator
1991: l_measure.aggregation_method := substr(i.source_formula, 1, instr(i.source_formula, '(')-1);
1992: l_measure.datatype := 'NUMBER';
1993: l_measure.measure_group := i.measure_group_id;
1994: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);
1995: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);
1996: -- Bug 4540103 if its a BSCIC column check which B table its from
1997: if i.column_name like 'BSCIC%' then
1998: if is_BSCIC_column_from_b_table(l_lowest_s_table, p_base_table, i.column_name) then

Line 1995: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);

1991: l_measure.aggregation_method := substr(i.source_formula, 1, instr(i.source_formula, '(')-1);
1992: l_measure.datatype := 'NUMBER';
1993: l_measure.measure_group := i.measure_group_id;
1994: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID, i.projection_id);
1995: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.SOURCE_FORMULA, i.source_formula);
1996: -- Bug 4540103 if its a BSCIC column check which B table its from
1997: if i.column_name like 'BSCIC%' then
1998: if is_BSCIC_column_from_b_table(l_lowest_s_table, p_base_table, i.column_name) then
1999: l_measure_list(l_measure_list.count+1) := l_measure;

Line 2102: l_level.level_pk_datatype := BSC_DBGEN_UTILS.get_datatype(l_level.level_table_name, l_level.level_pk);

2098: l_level.level_name := i.level_table_name;
2099: l_level.level_table_name := i.level_table_name;
2100: l_level.level_fk := i.level_pk_col;
2101: l_level.level_pk := 'CODE';
2102: l_level.level_pk_datatype := BSC_DBGEN_UTILS.get_datatype(l_level.level_table_name, l_level.level_pk);
2103: l_level_list(l_level_list.count+1) := l_level;
2104: END LOOP;
2105: return l_level_list;
2106: Exception when others then

Line 2394: IF (bsc_dbgen_utils.get_property_value(l_properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID) <> '0') THEN

2390: l_measures := bsc_dbgen_metadata_reader.get_measures_for_fact(p_kpi, l_dim_sets(i));
2391: IF (l_measures.count > 0) THEN
2392: FOR j IN l_measures.first..l_measures.last LOOP
2393: l_properties := l_measures(j).Properties;
2394: IF (bsc_dbgen_utils.get_property_value(l_properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID) <> '0') THEN
2395: RETURN 'Y';
2396: END IF;
2397: END LOOP;
2398: END IF;