eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_AW_ADAPTER_DIM dependencies on BSC_AW_DBMS_AW

Line 770: bsc_aw_dbms_aw.execute(g_stmt);

766: --dim datatype is always text. we ran perf prototype and found that with text, we have the
767: --best aggregation perf
768: l_dim_data_type:='TEXT';
769: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).level_name||' dimension '||l_dim_data_type;
770: bsc_aw_dbms_aw.execute(g_stmt);
771: p_dimension.level_groups(1).levels(i).filter_variable:=p_dimension.level_groups(1).levels(i).level_name||'.filter.bool';
772: p_dimension.level_groups(1).levels(i).limit_variable:=p_dimension.level_groups(1).levels(i).level_name||'.LB';
773: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).filter_variable||' variable boolean <'||
774: p_dimension.level_groups(1).levels(i).level_name||'>';

Line 775: bsc_aw_dbms_aw.execute(g_stmt);

771: p_dimension.level_groups(1).levels(i).filter_variable:=p_dimension.level_groups(1).levels(i).level_name||'.filter.bool';
772: p_dimension.level_groups(1).levels(i).limit_variable:=p_dimension.level_groups(1).levels(i).level_name||'.LB';
773: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).filter_variable||' variable boolean <'||
774: p_dimension.level_groups(1).levels(i).level_name||'>';
775: bsc_aw_dbms_aw.execute(g_stmt);
776: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).limit_variable||' variable boolean <'||
777: p_dimension.level_groups(1).levels(i).level_name||'>';
778: bsc_aw_dbms_aw.execute(g_stmt);
779: --if std dim, do not add 0

Line 778: bsc_aw_dbms_aw.execute(g_stmt);

774: p_dimension.level_groups(1).levels(i).level_name||'>';
775: bsc_aw_dbms_aw.execute(g_stmt);
776: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).limit_variable||' variable boolean <'||
777: p_dimension.level_groups(1).levels(i).level_name||'>';
778: bsc_aw_dbms_aw.execute(g_stmt);
779: --if std dim, do not add 0
780: if p_dimension.dim_type<>'std' then
781: g_stmt:='maintain '||p_dimension.level_groups(1).levels(i).level_name||' merge ''0''';
782: bsc_aw_dbms_aw.execute(g_stmt);

Line 782: bsc_aw_dbms_aw.execute(g_stmt);

778: bsc_aw_dbms_aw.execute(g_stmt);
779: --if std dim, do not add 0
780: if p_dimension.dim_type<>'std' then
781: g_stmt:='maintain '||p_dimension.level_groups(1).levels(i).level_name||' merge ''0''';
782: bsc_aw_dbms_aw.execute(g_stmt);
783: end if;
784: --see if there are seed values to enter
785: --if seed value is a text, it will be entered as '''seedvalue''' . see create_projection_dim
786: for j in 1..p_dimension.level_groups(1).levels(i).seed_values.count loop

Line 788: bsc_aw_dbms_aw.execute(g_stmt);

784: --see if there are seed values to enter
785: --if seed value is a text, it will be entered as '''seedvalue''' . see create_projection_dim
786: for j in 1..p_dimension.level_groups(1).levels(i).seed_values.count loop
787: g_stmt:='maintain '||p_dimension.level_groups(1).levels(i).level_name||' merge '||p_dimension.level_groups(1).levels(i).seed_values(j);
788: bsc_aw_dbms_aw.execute(g_stmt);
789: end loop;
790: end loop;
791: --for the recursive levels
792: for i in 1..p_dimension.level_groups(1).rec_levels.count loop

Line 794: bsc_aw_dbms_aw.execute(g_stmt);

790: end loop;
791: --for the recursive levels
792: for i in 1..p_dimension.level_groups(1).rec_levels.count loop
793: g_stmt:='dfn '||p_dimension.level_groups(1).rec_levels(i).level_name||' dimension '||l_dim_data_type;
794: bsc_aw_dbms_aw.execute(g_stmt);
795: end loop;
796: Exception when others then
797: log_n('Exception in create_dim_for_levels '||sqlerrm);
798: raise;

Line 817: bsc_aw_dbms_aw.execute(g_stmt);

813: l_levels(l_levels.count+1):=p_dimension.level_groups(1).rec_levels(i).level_name;
814: end loop;
815: g_stmt:=substr(g_stmt,1,length(g_stmt)-1);
816: g_stmt:=g_stmt||')';
817: bsc_aw_dbms_aw.execute(g_stmt);
818: --add the levels. this is reqd when dim merge happens
819: for i in 1..l_levels.count loop
820: g_stmt:='CHGDFN '||p_dimension.dim_name||' base add '||l_levels(i);
821: bsc_aw_dbms_aw.execute(g_stmt); --we have added ORA-36656 to ignore list

Line 821: bsc_aw_dbms_aw.execute(g_stmt); --we have added ORA-36656 to ignore list

817: bsc_aw_dbms_aw.execute(g_stmt);
818: --add the levels. this is reqd when dim merge happens
819: for i in 1..l_levels.count loop
820: g_stmt:='CHGDFN '||p_dimension.dim_name||' base add '||l_levels(i);
821: bsc_aw_dbms_aw.execute(g_stmt); --we have added ORA-36656 to ignore list
822: end loop;
823: p_dimension.filter_variable:=p_dimension.dim_name||'.filter.bool';
824: p_dimension.limit_variable:=p_dimension.dim_name||'.LB';
825: p_dimension.base_value_cube:=p_dimension.dim_name||'.BV';

Line 827: bsc_aw_dbms_aw.execute(g_stmt);

823: p_dimension.filter_variable:=p_dimension.dim_name||'.filter.bool';
824: p_dimension.limit_variable:=p_dimension.dim_name||'.LB';
825: p_dimension.base_value_cube:=p_dimension.dim_name||'.BV';
826: g_stmt:='dfn '||p_dimension.filter_variable||' variable boolean <'||p_dimension.dim_name||'>';
827: bsc_aw_dbms_aw.execute(g_stmt);
828: g_stmt:='dfn '||p_dimension.limit_variable||' variable boolean <'||p_dimension.dim_name||'>';
829: bsc_aw_dbms_aw.execute(g_stmt);
830: g_stmt:='dfn '||p_dimension.base_value_cube||' variable TEXT <'||p_dimension.dim_name||'>';
831: bsc_aw_dbms_aw.execute(g_stmt);

Line 829: bsc_aw_dbms_aw.execute(g_stmt);

825: p_dimension.base_value_cube:=p_dimension.dim_name||'.BV';
826: g_stmt:='dfn '||p_dimension.filter_variable||' variable boolean <'||p_dimension.dim_name||'>';
827: bsc_aw_dbms_aw.execute(g_stmt);
828: g_stmt:='dfn '||p_dimension.limit_variable||' variable boolean <'||p_dimension.dim_name||'>';
829: bsc_aw_dbms_aw.execute(g_stmt);
830: g_stmt:='dfn '||p_dimension.base_value_cube||' variable TEXT <'||p_dimension.dim_name||'>';
831: bsc_aw_dbms_aw.execute(g_stmt);
832: Exception when others then
833: log_n('Exception in create_ccdim '||sqlerrm);

Line 831: bsc_aw_dbms_aw.execute(g_stmt);

827: bsc_aw_dbms_aw.execute(g_stmt);
828: g_stmt:='dfn '||p_dimension.limit_variable||' variable boolean <'||p_dimension.dim_name||'>';
829: bsc_aw_dbms_aw.execute(g_stmt);
830: g_stmt:='dfn '||p_dimension.base_value_cube||' variable TEXT <'||p_dimension.dim_name||'>';
831: bsc_aw_dbms_aw.execute(g_stmt);
832: Exception when others then
833: log_n('Exception in create_ccdim '||sqlerrm);
834: raise;
835: End;

Line 865: bsc_aw_dbms_aw.execute(g_stmt);

861: procedure create_level_name_dim(p_dimension in out nocopy dimension_r) is
862: Begin
863: p_dimension.level_name_dim:=p_dimension.dim_name||'.levels';
864: g_stmt:='dfn '||p_dimension.level_name_dim||' dimension text';
865: bsc_aw_dbms_aw.execute(g_stmt);
866: if p_dimension.recursive='Y' then
867: if p_dimension.recursive_norm_hier='N' then
868: --we create the cube that is used to store the position of the level values
869: --larry will have 1, john wookey 2 etc. before agg we do limit .levels to .levels.position LE adv_sum_profile

Line 873: bsc_aw_dbms_aw.execute(g_stmt);

869: --larry will have 1, john wookey 2 etc. before agg we do limit .levels to .levels.position LE adv_sum_profile
870: --this name .position is assumes in bsc_aw_load_kpi.limit_dim_levels
871: p_dimension.rec_level_position_cube:=p_dimension.dim_name||'.levels.position';
872: g_stmt:='dfn '||p_dimension.rec_level_position_cube||' number<'||p_dimension.level_name_dim||'>';
873: bsc_aw_dbms_aw.execute(g_stmt);
874: else
875: g_stmt:='maintain '||p_dimension.level_name_dim||' merge ''1'''; --default
876: bsc_aw_dbms_aw.execute(g_stmt);
877: end if;

Line 876: bsc_aw_dbms_aw.execute(g_stmt);

872: g_stmt:='dfn '||p_dimension.rec_level_position_cube||' number<'||p_dimension.level_name_dim||'>';
873: bsc_aw_dbms_aw.execute(g_stmt);
874: else
875: g_stmt:='maintain '||p_dimension.level_name_dim||' merge ''1'''; --default
876: bsc_aw_dbms_aw.execute(g_stmt);
877: end if;
878: else
879: for i in 1..p_dimension.level_groups(1).parent_child.count loop
880: if p_dimension.level_groups(1).parent_child(i).parent_level is not null

Line 884: bsc_aw_dbms_aw.execute(g_stmt);

880: if p_dimension.level_groups(1).parent_child(i).parent_level is not null
881: and p_dimension.level_groups(1).parent_child(i).child_level is not null then
882: g_stmt:='maintain '||p_dimension.level_name_dim||' merge '''||p_dimension.level_groups(1).parent_child(i).parent_level||'.'||
883: p_dimension.level_groups(1).parent_child(i).child_level||'''';
884: bsc_aw_dbms_aw.execute(g_stmt);
885: end if;
886: end loop;
887: --zero code
888: for i in 1..p_dimension.level_groups(1).zero_levels.count loop

Line 891: bsc_aw_dbms_aw.execute(g_stmt);

887: --zero code
888: for i in 1..p_dimension.level_groups(1).zero_levels.count loop
889: g_stmt:='maintain '||p_dimension.level_name_dim||' merge '''||p_dimension.level_groups(1).zero_levels(i).level_name||'.'||
890: p_dimension.level_groups(1).zero_levels(i).child_level_name||'''';
891: bsc_aw_dbms_aw.execute(g_stmt);
892: end loop;
893: end if;
894: --create level name dim for each level
895: if p_dimension.dim_type <> 'std' then

Line 899: bsc_aw_dbms_aw.execute(g_stmt);

895: if p_dimension.dim_type <> 'std' then
896: for i in 1..p_dimension.level_groups(1).levels.count loop
897: p_dimension.level_groups(1).levels(i).level_name_dim:=p_dimension.level_groups(1).levels(i).level_name||'.levels';
898: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).level_name_dim||' dimension text';
899: bsc_aw_dbms_aw.execute(g_stmt);
900: g_stmt:='maintain '||p_dimension.level_groups(1).levels(i).level_name_dim||' merge '''||
901: get_zero_level(p_dimension,p_dimension.level_groups(1).levels(i).level_name).level_name||'.'||
902: p_dimension.level_groups(1).levels(i).level_name||'''';
903: bsc_aw_dbms_aw.execute(g_stmt);

Line 903: bsc_aw_dbms_aw.execute(g_stmt);

899: bsc_aw_dbms_aw.execute(g_stmt);
900: g_stmt:='maintain '||p_dimension.level_groups(1).levels(i).level_name_dim||' merge '''||
901: get_zero_level(p_dimension,p_dimension.level_groups(1).levels(i).level_name).level_name||'.'||
902: p_dimension.level_groups(1).levels(i).level_name||'''';
903: bsc_aw_dbms_aw.execute(g_stmt);
904: end loop;
905: end if;
906: --
907: Exception when others then

Line 917: bsc_aw_dbms_aw.execute(g_stmt);

913: */
914: procedure create_relation(p_dimension in out nocopy dimension_r) is
915: Begin
916: g_stmt:='dfn '||p_dimension.relation_name||' relation '||p_dimension.dim_name||'<'||p_dimension.dim_name||' '||p_dimension.level_name_dim||'>';
917: bsc_aw_dbms_aw.execute(g_stmt);
918: --create each level's relation
919: if p_dimension.dim_type <> 'std' then
920: for i in 1..p_dimension.level_groups(1).levels.count loop
921: p_dimension.level_groups(1).levels(i).relation_name:=p_dimension.level_groups(1).levels(i).level_name||'.rel';

Line 924: bsc_aw_dbms_aw.execute(g_stmt);

920: for i in 1..p_dimension.level_groups(1).levels.count loop
921: p_dimension.level_groups(1).levels(i).relation_name:=p_dimension.level_groups(1).levels(i).level_name||'.rel';
922: g_stmt:='dfn '||p_dimension.level_groups(1).levels(i).relation_name||' relation '||p_dimension.level_groups(1).levels(i).level_name||'<'||
923: p_dimension.level_groups(1).levels(i).level_name||' '||p_dimension.level_groups(1).levels(i).level_name_dim||'>';
924: bsc_aw_dbms_aw.execute(g_stmt);
925: end loop;
926: end if;
927: Exception when others then
928: log_n('Exception in create_relation '||sqlerrm);

Line 1303: bsc_aw_dbms_aw.execute_ne('dfn temp_text text');

1299: procedure create_dim_program_rec_norm(p_dimension dimension_r,p_mode varchar2) is
1300: l_pgm varchar2(300);
1301: Begin
1302: --if the temp variable does not exist, create it.
1303: bsc_aw_dbms_aw.execute_ne('dfn temp_text text');
1304: g_commands.delete;
1305: if p_dimension.initial_load_program is not null then
1306: l_pgm:=p_dimension.initial_load_program;
1307: bsc_aw_utility.add_g_commands(g_commands,'dfn '||l_pgm||' program');

Line 1983: bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).parent_child(j).parent_level||'.'||

1979: end loop;
1980: if l_flag=false then
1981: if p_old_level_groups(i).parent_child(j).child_level is not null and p_old_level_groups(i).parent_child(j).parent_level is not null then
1982: --remove this
1983: bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).parent_child(j).parent_level||'.'||
1984: p_old_level_groups(i).parent_child(j).child_level||'''');
1985: end if;
1986: end if;
1987: end loop;

Line 2003: bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).zero_levels(j).level_name||'.'||

1999: exit;
2000: end if;
2001: end loop;
2002: if l_flag=false then
2003: bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).zero_levels(j).level_name||'.'||
2004: p_old_level_groups(i).zero_levels(j).child_level_name||'''');
2005: end if;
2006: end loop;
2007: end loop;