[Home] [Help]
1222: p_base_table in out nocopy base_table_r
1223: ) is
1224: --
1225: l_dim varchar2(300);
1226: l_parent_child bsc_aw_adapter_dim.dim_parent_child_tb;
1227: l_pc_subset bsc_aw_adapter_dim.dim_parent_child_tb;
1228: l_from_sql dbms_sql.varchar2_table;
1229: l_where_sql dbms_sql.varchar2_table;
1230: l_group_sql dbms_sql.varchar2_table;
1223: ) is
1224: --
1225: l_dim varchar2(300);
1226: l_parent_child bsc_aw_adapter_dim.dim_parent_child_tb;
1227: l_pc_subset bsc_aw_adapter_dim.dim_parent_child_tb;
1228: l_from_sql dbms_sql.varchar2_table;
1229: l_where_sql dbms_sql.varchar2_table;
1230: l_group_sql dbms_sql.varchar2_table;
1231: l_base_cal_column varchar2(100); --lower periodicity column name from bsc_db_calendar
1270: l_parent_child.delete;
1271: l_pc_subset.delete;
1272: bsc_aw_md_api.get_dim_for_level(p_base_table.levels(i).level_name,l_dim);
1273: bsc_aw_md_api.get_dim_parent_child(l_dim,l_parent_child);
1274: l_pc_subset:=bsc_aw_adapter_dim.get_hier_subset(l_parent_child,get_dim_given_dim_name(l_dim,p_data_source.dim).levels(1).level_name,
1275: p_base_table.levels(i).level_name);
1276: if l_pc_subset.count=0 then
1277: log('Could not rollup from B table to dimset '||p_base_table.base_table_name||', at level '||p_base_table.levels(i).level_name);
1278: raise bsc_aw_utility.g_exception;
5350: raise;
5351: End;
5352:
5353: procedure set_PT_dim_aggregated(p_dim in out nocopy dim_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table) is
5354: l_parent_child bsc_aw_adapter_dim.dim_parent_child_tb;
5355: l_pc bsc_aw_utility.parent_child_tb;
5356: l_child_levels dbms_sql.varchar2_table;
5357: zero_aggregated dbms_sql.varchar2_table;
5358: aggregated dbms_sql.varchar2_table;
6076: /*p_dim can be normal or std dim */
6077: procedure set_DS_hpt_rollup_data(p_DS_dim dim_tb,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r) is
6078: l_dim_parent_child parent_child_tb;/*for initialization */
6079: l_index number;
6080: l_parent_child bsc_aw_adapter_dim.dim_parent_child_tb;
6081: l_pc_subset bsc_aw_adapter_dim.dim_parent_child_tb;
6082: l_child_levels dbms_sql.varchar2_table;
6083: Begin
6084: for i in 1..p_DS_dim.count loop
6077: procedure set_DS_hpt_rollup_data(p_DS_dim dim_tb,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r) is
6078: l_dim_parent_child parent_child_tb;/*for initialization */
6079: l_index number;
6080: l_parent_child bsc_aw_adapter_dim.dim_parent_child_tb;
6081: l_pc_subset bsc_aw_adapter_dim.dim_parent_child_tb;
6082: l_child_levels dbms_sql.varchar2_table;
6083: Begin
6084: for i in 1..p_DS_dim.count loop
6085: for j in 1..p_hpt_data.hpt_dimensions.count loop /*hpt_dimension does not include time */
6112: l_pc_subset.delete;
6113: l_child_levels.delete;
6114: bsc_aw_md_api.get_dim_parent_child(p_DS_dim(i).dim_name,l_parent_child);
6115: l_child_levels(l_child_levels.count+1):=p_DS_dim(i).levels(1).level_name;
6116: l_pc_subset:=bsc_aw_adapter_dim.get_hier_subset(l_parent_child,p_hpt_data.hpt_dimensions(j).level_names,l_child_levels);
6117: if l_pc_subset.count=0 then
6118: log('Could not rollup from '||p_DS_dim(i).levels(1).level_name||' to higher levels like '||p_hpt_data.hpt_dimensions(j).level_names(1));
6119: log('This means we cannot rollup from the dim level of the DS to the dim level at which the partition is defined. This is not allowed');
6120: raise bsc_aw_utility.g_exception;