[Home] [Help]
50: if l_parameters(i).dimension='DIMENSION' then
51: l_short_name(l_short_name.count+1):=l_parameters(i).parameter_name;
52: end if;
53: end loop;
54: bsc_aw_bsc_metadata.get_dim_levels_for_short_names(l_short_name,l_dim);
55: j:=1;
56: for i in 1..l_parameters.count loop
57: if l_parameters(i).dimension='DIMENSION' then
58: l_parameters(i).parameter_name:=l_dim(j);
65: if l_parameters(i).dimension='MEASURE' then
66: l_short_name(l_short_name.count+1):=l_parameters(i).parameter_name;
67: end if;
68: end loop;
69: bsc_aw_bsc_metadata.get_measures_for_short_names(l_short_name,l_measure);
70: j:=1;
71: for i in 1..l_parameters.count loop
72: if l_parameters(i).dimension='MEASURE' then
73: l_parameters(i).parameter_name:=l_measure(j);
138: if g_debug then
139: dmp_parameters(l_parameters);
140: end if;
141:
142: IF BSC_METADATA_OPTIMIZER_PKG.is_totally_shared_obj(p_kpi) THEN
143: --totally shared objectives dont have AW summary objects
144: SELECT source_indicator INTO l_kpi
145: FROM bsc_kpis_b
146: WHERE indicator = p_kpi;
228: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
229: l_dim_set varchar2(100);
230: Begin
231: g_kpi(p_kpi).kpi:=p_kpi;
232: g_kpi(p_kpi).property.last_update_date:=bsc_metadata.get_kpi_LUD(p_kpi);
233: g_kpi(p_kpi).dim_set.delete;
234: g_kpi(p_kpi).dim_set_id.delete;
235: --
236: bsc_aw_md_api.get_kpi_dimset(p_kpi,l_olap_object);
1518:
1519: function check_kpi_change(p_kpi varchar2) return boolean is
1520: l_date date;
1521: Begin
1522: l_date:=bsc_metadata.get_kpi_LUD(p_kpi);
1523: if l_date>g_kpi(p_kpi).property.last_update_date then
1524: return true;
1525: end if;
1526: return false;