[Home] [Help]
211: procedure drop_kpi(p_kpi varchar2) is
212: Begin
213: default_context_if_null;
214: if g_debug then
215: log('drop kpi metadata '||p_kpi||bsc_aw_utility.get_time);
216: end if;
217: if p_kpi is not null then
218: delete bsc_olap_object_relation where parent_object_type='kpi' and parent_object=p_kpi and context=g_context;
219: delete bsc_olap_object_relation where object=p_kpi and object_type='kpi' and relation_object=p_kpi and relation_object_type='kpi' and
320: and parent_object_type=p_parent_type and context=g_context order by object_type;
321: cursor c6 is select * from bsc_olap_object where object_type=p_type and parent_object_type=p_parent_type and context=g_context;
322: Begin
323: default_context_if_null;
324: if g_debug and bsc_aw_utility.g_debug_level='all' then
325: log(' get_bsc_olap_object object='||p_object||' type='||p_type||' parent_object='||p_parent_object||' po_type='||
326: p_parent_type);
327: end if;
328: if p_object is null and p_type is null and p_parent_object is not null and p_parent_type is not null then --given the parent, get the objects
409: and context=g_context;
410: --
411: Begin
412: default_context_if_null;
413: if g_debug and bsc_aw_utility.g_debug_level='all' then
414: log(' get_bsc_olap_object_relation object='||p_object||' type='||p_object_type||' rel_type='||
415: p_relation_type||' par_obj='||p_parent_object||' par_obj_type='||p_parent_object_type);
416: end if;
417: if p_object is not null and p_relation_type is null and p_parent_object is not null then
465: procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r) is
466: Begin
467: default_context_if_null;
468: if g_debug then
469: log('create kpi metadata '||p_kpi.kpi||bsc_aw_utility.get_time);
470: end if;
471: --=======bsc olap objects====================
472: insert_olap_object(p_kpi.kpi,'kpi',null,null,p_kpi.kpi,'kpi','calendar='||p_kpi.calendar||',parent kpi='||p_kpi.parent_kpi);
473: for i in 1..p_kpi.dim_set.count loop
877: l_property:=l_property||p_dim_set.measure(i).agg_formula.measures(j)||'+';
878: end loop;
879: l_property:=l_property||',';
880: end if;
881: l_property:=l_property||bsc_aw_utility.get_property_string(p_dim_set.measure(i).property);
882: insert_olap_object_relation(p_dim_set.dim_set_name,'kpi dimension set',p_dim_set.measure(i).measure,'measure',
883: 'dim set measure',p_kpi,'kpi',l_property);
884: end loop;
885: --programs
909: --given base tables, find the dimension sets they impact
910: --this is imp because, if we need to load a base table, we need tofind the dim set they impact and then load them
911: --data sources can share base tables. so first get the distinct list...this is not imp. if base table -> dim set repeats,
912: --its ok
913: bsc_aw_utility.init_is_new_value(1);
914: for i in 1..p_dim_set.inc_data_source.count loop
915: for j in 1..p_dim_set.inc_data_source(i).base_tables.count loop
916: if bsc_aw_utility.is_new_value(p_dim_set.inc_data_source(i).base_tables(j).base_table_name,1) then
917: --note>>>load kpi module (api load_kpi_dimset_base_table) has dependency on how property looks like.
912: --its ok
913: bsc_aw_utility.init_is_new_value(1);
914: for i in 1..p_dim_set.inc_data_source.count loop
915: for j in 1..p_dim_set.inc_data_source(i).base_tables.count loop
916: if bsc_aw_utility.is_new_value(p_dim_set.inc_data_source(i).base_tables(j).base_table_name,1) then
917: --note>>>load kpi module (api load_kpi_dimset_base_table) has dependency on how property looks like.
918: --if l_property needs to be changed, make the change in load kpi module also
919: l_property:='base table periodicity='||p_dim_set.inc_data_source(i).base_tables(j).periodicity.periodicity||
920: ',current change vector=0,measures=';
1180: if g_debug then
1181: log('delete_olap_object_relation:object='||p_object||', object_type='||p_object_type||
1182: ', p_relation_type='||p_relation_type||', p_relation_object='||p_relation_object||
1183: ', p_relation_object_type='||p_relation_object_type||', p_parent_object='||p_parent_object||
1184: ', p_parent_object_type='||p_parent_object_type||bsc_aw_utility.get_time);
1185: end if;
1186: delete bsc_olap_object_relation
1187: where object=nvl(p_object,object)
1188: and object_type=nvl(p_object_type,object_type)
1192: and parent_object=nvl(p_parent_object,parent_object)
1193: and parent_object_type=nvl(p_parent_object_type,parent_object_type)
1194: and context=g_context;
1195: if g_debug then
1196: log('Deleted '||sql%rowcount||' rows'||bsc_aw_utility.get_time);
1197: end if;
1198: Exception when others then
1199: log_n('Exception in delete_olap_object_relation '||sqlerrm);
1200: raise;
1212: default_context_if_null;
1213: if g_debug then
1214: log('delete_olap_object:object='||p_object||', object_type='||p_object_type||
1215: ', p_olap_object='||p_olap_object||', p_olap_object_type='||p_olap_object_type||
1216: ', p_parent_object='||p_parent_object||', p_parent_object_type='||p_parent_object_type||bsc_aw_utility.get_time);
1217: end if;
1218: delete bsc_olap_object
1219: where object=nvl(p_object,object)
1220: and object_type=nvl(p_object_type,object_type)
1223: and parent_object=nvl(p_parent_object,parent_object)
1224: and parent_object_type=nvl(p_parent_object_type,parent_object_type)
1225: and context=g_context;
1226: if g_debug then
1227: log('Deleted '||sql%rowcount||' rows'||bsc_aw_utility.get_time);
1228: end if;
1229: Exception when others then
1230: log_n('Exception in delete_olap_object '||sqlerrm);
1231: raise;
1294: */
1295:
1296: procedure analyze_md_tables is
1297: Begin
1298: bsc_aw_utility.analyze_table('BSC_OLAP_OBJECT',60);
1299: bsc_aw_utility.analyze_table('BSC_OLAP_OBJECT_RELATION',60);
1300: Exception when others then
1301: log_n('Exception in analyze_md_tables '||sqlerrm);
1302: raise;
1295:
1296: procedure analyze_md_tables is
1297: Begin
1298: bsc_aw_utility.analyze_table('BSC_OLAP_OBJECT',60);
1299: bsc_aw_utility.analyze_table('BSC_OLAP_OBJECT_RELATION',60);
1300: Exception when others then
1301: log_n('Exception in analyze_md_tables '||sqlerrm);
1302: raise;
1303: End;
1305: -------------------------------
1306: procedure init_all is
1307: Begin
1308: g_context:='AW';--default
1309: g_who:=bsc_aw_utility.get_who;
1310: g_debug:=bsc_aw_utility.g_debug;
1311: Exception when others then
1312: null;
1313: End;
1306: procedure init_all is
1307: Begin
1308: g_context:='AW';--default
1309: g_who:=bsc_aw_utility.get_who;
1310: g_debug:=bsc_aw_utility.g_debug;
1311: Exception when others then
1312: null;
1313: End;
1314:
1313: End;
1314:
1315: procedure log(p_message varchar2) is
1316: Begin
1317: bsc_aw_utility.log(p_message);
1318: Exception when others then
1319: null;
1320: End;
1321: