[Home] [Help]
94: l_facts:=bsc_dbgen_metadata_reader.get_facts_for_levels(l_levels);
95: --now, match these with the facts implemented in aw
96: get_all_kpi_in_aw(l_all_kpis);
97: for i in 1..l_facts.count loop
98: if bsc_aw_utility.in_array(l_all_kpis,to_char(l_facts(i).fact_id)) then
99: for j in 1..l_facts(i).dimension_set.count loop
100: p_kpi(p_kpi.count+1):=l_facts(i).fact_id;
101: p_dimset(p_dimset.count+1):=l_facts(i).dimension_set(j);
102: end loop;
117: for i in 1..p_kpi_list.count loop
118: l_dimensions.delete;
119: l_dimensions:=bsc_dbgen_metadata_reader.get_all_levels_for_fact(p_kpi_list(i));
120: for j in 1..l_dimensions.count loop
121: if bsc_aw_utility.in_array(p_dim_list,l_dimensions(j))=false then
122: p_dim_list(p_dim_list.count+1):=l_dimensions(j);
123: end if;
124: end loop;
125: end loop;
308: --there is only hier that arun is using. levels are in order of parent to child. so we reverse the order
309: for i in 1..l_dimension.count loop
310: for j in 1..l_dimension(i).Hierarchies.count loop
311: for k in reverse 1..l_dimension(i).Hierarchies(j).Levels.count loop
312: if bsc_aw_utility.in_array(p_dim_level,l_dimension(i).Hierarchies(j).Levels(k).level_name)=false then
313: p_dim_level(p_dim_level.count+1):=l_dimension(i).Hierarchies(j).Levels(k).level_name;
314: p_skip_level(p_skip_level.count+1):='N';--hardcoded since we call get_dimensions_for_fact with false
315: p_mo_dim_group(p_mo_dim_group.count+1):=i;--dim name will be null. so use i
316: end if;
411: for i in 1..l_dimension.count loop
412: for j in 1..l_dimension(i).Hierarchies.count loop
413: for k in reverse 1..l_dimension(i).Hierarchies(j).Levels.count loop
414: if bsc_dbgen_utils.get_property_value(l_dimension(i).Hierarchies(j).Levels(k).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
415: if bsc_aw_utility.in_array(p_dim_level,l_dimension(i).Hierarchies(j).Levels(k).level_name)=false then
416: p_dim_level(p_dim_level.count+1):=l_dimension(i).Hierarchies(j).Levels(k).level_name;
417: end if;
418: end if;
419: end loop;
446: l_flag:=false;
447: --say year and qtr show up. for year, qtr is a src. so qtr will show up as a parent period of year
448: for j in 1..l_periodicity.count loop
449: if bsc_dbgen_utils.get_property_value(l_periodicity(j).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
450: if bsc_aw_utility.in_array(l_periodicity(i).Parent_periods,to_char(l_periodicity(j).Periodicity_id)) then
451: l_flag:=true;
452: exit;
453: end if;
454: end if;
491: --
492: l_filter varchar2(32000);
493: Begin
494: l_filter:=bsc_dbgen_metadata_reader.get_filter_for_dim_level(p_kpi,p_level);
495: bsc_aw_utility.convert_varchar2_to_table(l_filter,3800,p_filter);
496: Exception when others then
497: log_n('Exception in get_dim_level_filter '||sqlerrm);
498: raise;
499: End;
644:
645: procedure get_base_table_properties(
646: p_base_table varchar2,
647: p_prj_table out nocopy varchar2,
648: p_partition out nocopy bsc_aw_utility.object_partition_r) is
649: --
650: l_partition_info BSC_DBGEN_STD_METADATA.clsTablePartition;
651: Begin
652: p_prj_table:=BSC_DBGEN_METADATA_READER.get_table_properties(p_base_table,BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);
827:
828: ------------------------------
829: procedure init_all is
830: Begin
831: g_debug:=bsc_aw_utility.g_debug;
832: Exception when others then
833: null;
834: End;
835:
834: End;
835:
836: procedure log(p_message varchar2) is
837: Begin
838: bsc_aw_utility.log(p_message);
839: Exception when others then
840: null;
841: End;
842: