[Home] [Help]
34: */
35: procedure limit_dimensions_pmv(
36: p_kpi varchar2,
37: p_dim_set varchar2,
38: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
39: ) is
40: --
41: l_short_name dbms_sql.varchar2_table;
42: l_dim dbms_sql.varchar2_table;
40: --
41: l_short_name dbms_sql.varchar2_table;
42: l_dim dbms_sql.varchar2_table;
43: l_measure dbms_sql.varchar2_table;
44: l_parameters BIS_PMV_PAGE_PARAMETER_TBL;
45: j integer;
46: Begin
47: l_parameters:=p_parameters;
48: l_short_name.delete;
120: */
121: procedure limit_dimensions(
122: p_kpi varchar2,
123: p_dim_set varchar2,
124: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
125: ) is
126: --
127: l_status varchar2(100);
128: l_kpi varchar2(100);
127: l_status varchar2(100);
128: l_kpi varchar2(100);
129: l_kpi_in_cache boolean;
130: l_agg_status varchar2(100);
131: l_parameters BIS_PMV_PAGE_PARAMETER_TBL;
132: Begin
133: if g_init is null or g_init=false then
134: init_all;
135: g_init:=true;
477:
478: /*5155595 there can be cases where a formula measure alone is being looked at. formula measures are represented as on-line agg . this means
479: if a formula measure alone is specified, no base measures get limited and nothing gets copied into display cube. we have to add relevant measures
480: to l_parameters */
481: procedure add_relevant_measures(p_dim_set dim_set_r,p_parameters in out nocopy BIS_PMV_PAGE_PARAMETER_TBL) is
482: l_measures dbms_sql.varchar2_table;
483: add_measures dbms_sql.varchar2_table;
484: add_all_measures boolean;
485: Begin
536: in future, there is more intelligent processing here
537: */
538: procedure check_limit_track_seq(
539: p_dim_set in out nocopy dim_set_r,
540: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
541: p_status out nocopy varchar2
542: ) is
543: --
544: l_count number;
555: we load limit_dim structure in this api for both dimensions and periodicities
556: */
557: procedure find_dimset_dimensions(
558: p_dim_set in out nocopy dim_set_r,
559: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
560: ) is
561: --
562: l_count number;
563: l_level varchar2(300);
601: this significantly improves performance
602: */
603: procedure set_viewby_dimensions(
604: p_dim_set in out nocopy dim_set_r,
605: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
606: p_limit_track in out nocopy limit_track_r
607: ) is
608: l_flag boolean;
609: l_dim_cache dbms_sql.varchar2_table;
641: iviewer can pass down a : separated list of as of dates
642: */
643: procedure find_dimset_xtd(
644: p_dim_set in out nocopy dim_set_r,
645: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
646: ) is
647: --
648: l_count number;
649: l_xtd_keys_table varchar2(100);
693: raise;
694: End;
695:
696: --rkumar: bug#5954342
697: procedure validate_limit_range(p_lower_period in out nocopy varchar2,p_upper_period in out nocopy varchar2, p_parameters BIS_PMV_PAGE_PARAMETER_TBL)
698: is
699: l_calendar_id number(5);
700: l_periodicity_id number(5);
701: l_limit_range varchar2(32000);
738: limit dim add level
739: */
740: procedure limit_dimset(
741: p_dim_set dim_set_r,
742: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
743: ) is
744: --
745: l_count number;
746: l_parse_values bsc_aw_utility.value_tb;--use in the case when TO is used
784: if p_dim_set.limit_track(l_count).limit_dim(i).value='^ALL' then
785: bsc_aw_dbms_aw.execute('limit '||p_dim_set.limit_track(l_count).limit_dim(i).level_name||' TO ALL');
786: else
787: --we need to handle time or any dim limited with the TO option. ie limit month_5_cal_1 to ''1.2004'' TO ''12.2004''
788: --input in BIS_PMV_PAGE_PARAMETER_TBL will be '1.2004 TO 12.2004'. we need to convert it to ''1.2004'' TO ''12.2004''
789: --when limiting, we use execute_ne so that even if the user has not loaded the kpi or is specifying unloaded values, we do not
790: --want the api to return error.
791: if instr(p_dim_set.limit_track(l_count).limit_dim(i).value,' TO ')>0 then
792: --rkumar: get the maximum and minimum values from the: Note.. need to modify the queries written below..
863: not be necessary.
864: */
865: procedure limit_dim_to_composite(
866: p_dim_set dim_set_r,
867: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
868: ) is
869: --
870: l_count number;
871: l_dim varchar2(300);
922: aggregate measures with formula
923: */
924: procedure aggregate_dimset_dimensions(
925: p_dim_set dim_set_r,
926: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
927: ) is
928: --
929: l_measures dbms_sql.varchar2_table;
930: l_agg_measures dbms_sql.varchar2_table;
1148: raise;
1149: End;
1150:
1151: procedure get_measures(
1152: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
1153: p_measures out nocopy dbms_sql.varchar2_table
1154: ) is
1155: Begin
1156: for i in 1..p_parameters.count loop
1495: log_n('Exception in detach_workspace '||sqlerrm);
1496: raise;
1497: End;
1498:
1499: procedure dmp_parameters(p_parameters BIS_PMV_PAGE_PARAMETER_TBL) is
1500: Begin
1501: log('Parameter dmp');
1502: for i in 1..p_parameters.count loop
1503: log(p_parameters(i).parameter_name||' '||p_parameters(i).parameter_id||' '||p_parameters(i).parameter_value||' '||p_parameters(i).dimension);
1531:
1532: /*when there are partitions and CC, we need display cubes to handle aggregations on the fly. CC cubes cannot be aggregated on the fly
1533: if there are balance measures that are already aggregated in time, these have to be copied too. so we should not lose the data at the
1534: specified dim levels*/
1535: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_parameters BIS_PMV_PAGE_PARAMETER_TBL) is
1536: l_measures dbms_sql.varchar2_table;
1537: Begin
1538: get_measures(p_parameters,l_measures);
1539: copy_data_display_cubes(p_dim_set,l_measures);