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_READ dependencies on BSC_AW_UTILITY

Line 246: l_dim_set:=bsc_aw_utility.get_parameter_value(l_olap_object(i).property1,'dim set',',');

242: g_kpi(p_kpi).status:='aw kpi';
243: --get dimset info for actuals
244: for i in 1..l_olap_object.count loop
245: if instr(l_olap_object(i).property1,'dim set type=actual') > 0 then
246: l_dim_set:=bsc_aw_utility.get_parameter_value(l_olap_object(i).property1,'dim set',',');
247: g_kpi(p_kpi).dim_set_id(g_kpi(p_kpi).dim_set_id.count+1):=l_dim_set;
248: bsc_aw_md_api.get_kpi_dimset_md(p_kpi,l_olap_object(i).object,g_kpi(p_kpi).dim_set(l_dim_set).dim_set);
249: end if;
250: end loop;

Line 497: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure)) then

493: add_all_measures:=true;
494: else /*if there are sql agg measures, make sure base measures are also in */
495: for i in 1..p_dim_set.dim_set.measure.count loop
496: if nvl(p_dim_set.dim_set.measure(i).sql_aggregated,'N')='Y' and p_dim_set.dim_set.measure(i).agg_formula.std_aggregation='N' then
497: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure)) then
498: if p_dim_set.dim_set.measure(i).agg_formula.measures.count>0 then /*add if the measures are not present */
499: for j in 1..p_dim_set.dim_set.measure(i).agg_formula.measures.count loop
500: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)))=false then
501: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)));

Line 500: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)))=false then

496: if nvl(p_dim_set.dim_set.measure(i).sql_aggregated,'N')='Y' and p_dim_set.dim_set.measure(i).agg_formula.std_aggregation='N' then
497: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure)) then
498: if p_dim_set.dim_set.measure(i).agg_formula.measures.count>0 then /*add if the measures are not present */
499: for j in 1..p_dim_set.dim_set.measure(i).agg_formula.measures.count loop
500: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)))=false then
501: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)));
502: end if;
503: end loop;
504: else /*play safe. add all measures */

Line 501: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)));

497: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure)) then
498: if p_dim_set.dim_set.measure(i).agg_formula.measures.count>0 then /*add if the measures are not present */
499: for j in 1..p_dim_set.dim_set.measure(i).agg_formula.measures.count loop
500: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)))=false then
501: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).agg_formula.measures(j)));
502: end if;
503: end loop;
504: else /*play safe. add all measures */
505: add_all_measures:=true;

Line 514: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure))=false then

510: end if;
511: if add_all_measures then
512: for i in 1..p_dim_set.dim_set.measure.count loop
513: if nvl(p_dim_set.dim_set.measure(i).sql_aggregated,'N')='N' then
514: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure))=false then
515: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).measure));
516: end if;
517: end if;
518: end loop;

Line 515: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).measure));

511: if add_all_measures then
512: for i in 1..p_dim_set.dim_set.measure.count loop
513: if nvl(p_dim_set.dim_set.measure(i).sql_aggregated,'N')='N' then
514: if bsc_aw_utility.in_array(l_measures,upper(p_dim_set.dim_set.measure(i).measure))=false then
515: bsc_aw_utility.merge_value(add_measures,upper(p_dim_set.dim_set.measure(i).measure));
516: end if;
517: end if;
518: end loop;
519: end if;

Line 624: if bsc_aw_utility.in_array(g_std_dim,p_dim_set.level_names(i))=false

620: end if;
621: end loop;
622: --we will add this level only if there is no dim for this level
623: if l_flag=false then --view by level
624: if bsc_aw_utility.in_array(g_std_dim,p_dim_set.level_names(i))=false
625: and (p_dim_set.levels(p_dim_set.level_names(i)).dim_name is null or bsc_aw_utility.in_array(l_dim_cache,
626: p_dim_set.levels(p_dim_set.level_names(i)).dim_name)=false) then
627: p_limit_track.limit_dim(p_limit_track.limit_dim.count+1).level_name:=nvl(p_dim_set.levels(p_dim_set.level_names(i)).rec_parent_level,
628: p_dim_set.level_names(i));

Line 625: and (p_dim_set.levels(p_dim_set.level_names(i)).dim_name is null or bsc_aw_utility.in_array(l_dim_cache,

621: end loop;
622: --we will add this level only if there is no dim for this level
623: if l_flag=false then --view by level
624: if bsc_aw_utility.in_array(g_std_dim,p_dim_set.level_names(i))=false
625: and (p_dim_set.levels(p_dim_set.level_names(i)).dim_name is null or bsc_aw_utility.in_array(l_dim_cache,
626: p_dim_set.levels(p_dim_set.level_names(i)).dim_name)=false) then
627: p_limit_track.limit_dim(p_limit_track.limit_dim.count+1).level_name:=nvl(p_dim_set.levels(p_dim_set.level_names(i)).rec_parent_level,
628: p_dim_set.level_names(i));
629: p_limit_track.limit_dim(p_limit_track.limit_dim.count).dim_name:=p_dim_set.levels(p_dim_set.level_names(i)).dim_name;

Line 665: bsc_aw_utility.parse_parameter_values(p_parameters(i).parameter_name,':',l_xtd_report_date);

661: l_xtd_keys_table:=p_parameters(i).parameter_name;
662: elsif p_parameters(i).dimension='XTD SESSION ID' then
663: l_xtd_session_id:=to_number(p_parameters(i).parameter_name);
664: elsif p_parameters(i).dimension='XTD REPORT DATE' then
665: bsc_aw_utility.parse_parameter_values(p_parameters(i).parameter_name,':',l_xtd_report_date);
666: end if;
667: end loop;
668: if l_xtd_keys_table is not null then
669: bsc_aw_utility.delete_table('bsc_aw_temp_vn',null);

Line 669: bsc_aw_utility.delete_table('bsc_aw_temp_vn',null);

665: bsc_aw_utility.parse_parameter_values(p_parameters(i).parameter_name,':',l_xtd_report_date);
666: end if;
667: end loop;
668: if l_xtd_keys_table is not null then
669: bsc_aw_utility.delete_table('bsc_aw_temp_vn',null);
670: forall i in 1..l_xtd_report_date.count
671: execute immediate 'insert into bsc_aw_temp_vn(name) values (:1)' using l_xtd_report_date(i);
672: g_stmt:='select to_char(periodicity_id),period||''.''||year period from '||l_xtd_keys_table||',bsc_aw_temp_vn where session_id=:1 and '||
673: 'to_char(report_date,''MM/DD/YYYY'')=bsc_aw_temp_vn.name order by periodicity_id';

Line 746: l_parse_values bsc_aw_utility.value_tb;--use in the case when TO is used

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
747: l_cache bsc_aw_utility.boolean_table;--to prevent same object from being set to null again and again
748:
749: l_lower_period varchar2(32000);
750: l_upper_period varchar2(32000);

Line 747: l_cache bsc_aw_utility.boolean_table;--to prevent same object from being set to null again and again

743: ) is
744: --
745: l_count number;
746: l_parse_values bsc_aw_utility.value_tb;--use in the case when TO is used
747: l_cache bsc_aw_utility.boolean_table;--to prevent same object from being set to null again and again
748:
749: l_lower_period varchar2(32000);
750: l_upper_period varchar2(32000);
751: Begin

Line 794: bsc_aw_utility.parse_parameter_values(p_dim_set.limit_track(l_count).limit_dim(i).value,' TO ',l_parse_values);

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..
793: l_parse_values.delete;
794: bsc_aw_utility.parse_parameter_values(p_dim_set.limit_track(l_count).limit_dim(i).value,' TO ',l_parse_values);
795: --see if its an year
796: l_lower_period:=l_parse_values(1).parameter;
797: l_upper_period:=l_parse_values(2).parameter;
798:

Line 896: if bsc_aw_utility.in_array(l_dim_cache,l_dim)=false then

892: else
893: l_dim:=p_dim_set.limit_track(l_count).limit_dim(i).level_name;
894: end if;
895: --
896: if bsc_aw_utility.in_array(l_dim_cache,l_dim)=false then
897: bsc_aw_dbms_aw.execute_ne('delete '||l_cube);
898: bsc_aw_dbms_aw.execute('dfn '||l_cube||' boolean <'||l_dim||'>');
899: bsc_aw_dbms_aw.execute(l_cube||' = true across '||l_composite);
900: bsc_aw_dbms_aw.execute('limit '||l_dim||' to '||l_cube);

Line 947: if bsc_aw_utility.in_array(l_level,p_dim_set.levels(p_parameters(i).parameter_name).level_name)=false then /process a level only one time /

943: then aggregate for each dim and then pop the dim
944: */
945: for i in 1..p_parameters.count loop
946: if p_parameters(i).dimension='DIMENSION' then
947: if bsc_aw_utility.in_array(l_level,p_dim_set.levels(p_parameters(i).parameter_name).level_name)=false then /*process a level only one time */
948: l_level(l_level.count+1):=p_dim_set.levels(p_parameters(i).parameter_name).level_name;
949: agg_dim_flag:=false;/*default */
950: l_zero_specified:=false;
951: if p_dim_set.levels(p_parameters(i).parameter_name).zero_level is not null then

Line 961: if bsc_aw_utility.in_array(l_dim_aggregate,p_dim_set.levels(p_parameters(i).parameter_name).dim_name)=false then

957: if p_dim_set.levels(p_parameters(i).parameter_name).aggregated='N' then
958: agg_dim_flag:=true;
959: end if;
960: if agg_dim_flag then
961: if bsc_aw_utility.in_array(l_dim_aggregate,p_dim_set.levels(p_parameters(i).parameter_name).dim_name)=false then
962: bsc_aw_dbms_aw.execute('push '||p_dim_set.levels(p_parameters(i).parameter_name).dim_name);
963: bsc_aw_dbms_aw.execute('limit '||p_dim_set.levels(p_parameters(i).parameter_name).level_name_dim||' TO NULL');
964: l_dim_aggregate(l_dim_aggregate.count+1):=p_dim_set.levels(p_parameters(i).parameter_name).dim_name;
965: end if;

Line 1020: if bsc_aw_utility.in_array(l_periodicity,p_dim_set.dim_set.calendar.periodicity(j).periodicity)=false then

1016: for i in 1..p_dim_set.limit_track(l_LT_index).limit_dim.count loop
1017: if p_dim_set.limit_track(l_LT_index).limit_dim(i).dim_type='PERIODICITY' then
1018: for j in 1..p_dim_set.dim_set.calendar.periodicity.count loop
1019: if p_dim_set.limit_track(l_LT_index).limit_dim(i).level_name=p_dim_set.dim_set.calendar.periodicity(j).aw_dim then
1020: if bsc_aw_utility.in_array(l_periodicity,p_dim_set.dim_set.calendar.periodicity(j).periodicity)=false then
1021: l_periodicity(l_periodicity.count+1):=p_dim_set.dim_set.calendar.periodicity(j).periodicity;
1022: end if;
1023: --
1024: exit;

Line 1102: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(l_measures(i))).cube)=false then

1098: end if;
1099: end loop;
1100: if l_measures.count>0 then
1101: for i in 1..l_measures.count loop
1102: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(l_measures(i))).cube)=false then
1103: l_cubes(l_cubes.count+1):=p_dim_set.measure(upper(l_measures(i))).cube;
1104: l_display_cubes(l_display_cubes.count+1):=p_dim_set.measure(upper(l_measures(i))).display_cube;
1105: end if;
1106: end loop;

Line 1248: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_std_measures(i))).cube)=false then

1244: l_countvar_cubes dbms_sql.varchar2_table;
1245: l_display_cubes dbms_sql.varchar2_table;
1246: Begin
1247: for i in 1..p_std_measures.count loop
1248: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_std_measures(i))).cube)=false then
1249: l_cubes(l_cubes.count+1):=p_dim_set.measure(upper(p_std_measures(i))).cube;
1250: l_countvar_cubes(l_countvar_cubes.count+1):=p_dim_set.measure(upper(p_std_measures(i))).countvar_cube;
1251: l_display_cubes(l_display_cubes.count+1):=p_dim_set.measure(upper(p_std_measures(i))).display_cube;
1252: end if;

Line 1353: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_measures(i))).agg_formula.cubes(j))=false then

1349: if p_dim_set.measure(upper(p_measures(i))).agg_formula.std_aggregation='N' and p_dim_set.measure(upper(p_measures(i))).sql_aggregated='N' then
1350: --
1351: l_cubes.delete;
1352: for j in 1..p_dim_set.measure(upper(p_measures(i))).agg_formula.cubes.count loop
1353: if bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_measures(i))).agg_formula.cubes(j))=false then
1354: l_cubes(l_cubes.count+1):=p_dim_set.measure(upper(p_measures(i))).agg_formula.cubes(j);
1355: end if;
1356: end loop;
1357: /*if we have non std agg, then we need to make sure that the source cubes for the formula are aggregated. this means we need to parse out

Line 1362: if bsc_aw_utility.in_array(p_agg_measures,p_dim_set.dim_set.measure(k).measure)=false then

1358: this info etc. so, to be safe, we look at all cubes that the given measures affect and then get all measures for these cubes */
1359: for j in 1..l_cubes.count loop
1360: for k in 1..p_dim_set.dim_set.measure.count loop
1361: if p_dim_set.dim_set.measure(k).cube=l_cubes(j) then
1362: if bsc_aw_utility.in_array(p_agg_measures,p_dim_set.dim_set.measure(k).measure)=false then
1363: p_agg_measures(p_agg_measures.count+1):=p_dim_set.dim_set.measure(k).measure;
1364: end if;
1365: --
1366: exit;

Line 1551: and bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_measures(i))).cube)=false then

1547: l_display_cubes dbms_sql.varchar2_table;
1548: Begin
1549: for i in 1..p_measures.count loop
1550: if p_dim_set.measure(upper(p_measures(i))).sql_aggregated='N'
1551: and bsc_aw_utility.in_array(l_cubes,p_dim_set.measure(upper(p_measures(i))).cube)=false then
1552: l_cubes(l_cubes.count+1):=p_dim_set.measure(upper(p_measures(i))).cube;
1553: l_display_cubes(l_display_cubes.count+1):=p_dim_set.measure(upper(p_measures(i))).display_cube;
1554: end if;
1555: end loop;

Line 1586: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'

1582:
1583: ---------------------------------------------------------------------------
1584: procedure init_all is
1585: Begin
1586: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
1587: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1588: g_debug:=true;
1589: else
1590: g_debug:=false;

Line 1587: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then

1583: ---------------------------------------------------------------------------
1584: procedure init_all is
1585: Begin
1586: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
1587: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1588: g_debug:=true;
1589: else
1590: g_debug:=false;
1591: end if;

Line 1592: bsc_aw_utility.init_all(g_debug);

1588: g_debug:=true;
1589: else
1590: g_debug:=false;
1591: end if;
1592: bsc_aw_utility.init_all(g_debug);
1593: BSC_AW_MD_API.init_all;
1594: bsc_aw_dbms_aw.init_all;
1595: bsc_aw_management.init_all;
1596: g_std_dim:=bsc_aw_adapter_dim.get_std_dim_list;

Line 1597: if nvl(bsc_aw_utility.get_parameter_value('FILE LOG'),'N')='Y' then

1593: BSC_AW_MD_API.init_all;
1594: bsc_aw_dbms_aw.init_all;
1595: bsc_aw_management.init_all;
1596: g_std_dim:=bsc_aw_adapter_dim.get_std_dim_list;
1597: if nvl(bsc_aw_utility.get_parameter_value('FILE LOG'),'N')='Y' then
1598: g_log_type:='file log';
1599: else
1600: g_log_type:='fnd log';
1601: end if;

Line 1609: bsc_aw_utility.log_fnd(p_message,bsc_aw_utility.g_log_level);

1605:
1606: procedure log(p_message varchar2) is
1607: Begin
1608: if g_log_type='fnd log' then
1609: bsc_aw_utility.log_fnd(p_message,bsc_aw_utility.g_log_level);
1610: else
1611: bsc_aw_utility.log(p_message);
1612: end if;
1613: Exception when others then

Line 1611: bsc_aw_utility.log(p_message);

1607: Begin
1608: if g_log_type='fnd log' then
1609: bsc_aw_utility.log_fnd(p_message,bsc_aw_utility.g_log_level);
1610: else
1611: bsc_aw_utility.log(p_message);
1612: end if;
1613: Exception when others then
1614: null;
1615: End;