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_LOAD_DIM dependencies on BSC_AW_MD_API

Line 32: bsc_aw_md_api.get_dim_for_level(p_dim_level_list(i),l_dim);

28: l_dim varchar2(300);
29: --
30: Begin
31: for i in 1..p_dim_level_list.count loop
32: bsc_aw_md_api.get_dim_for_level(p_dim_level_list(i),l_dim);
33: if bsc_aw_utility.in_array(l_dim_list,l_dim)=false then
34: l_dim_list(l_dim_list.count+1):=l_dim;
35: end if;
36: end loop;

Line 175: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_oo);

171: end if;
172: log_n('load_aw_dim, p_dim='||p_dim||', p_run_id='||p_run_id||', p_job_name='||p_job_name||
173: ', p_options='||p_options);
174: l_oo.delete;
175: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_oo);
176: for i in 1..l_oo.count loop
177: if l_oo(i).object_type='dml program' then
178: if l_oo(i).olap_object_type='dml program initial load' then
179: l_initial_load_pgm:=l_oo(i).object;

Line 286: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);

282: p_dim_level_delete('ALL').delete_name:='ALL';
283: p_dim_level_delete('ALL').delete_values.delete;
284: --get the dim levels
285: l_oo.delete;
286: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
287: --
288: if l_oo.count>0 then
289: for i in 1..l_oo.count loop
290: bsc_aw_utility.merge_value(p_dim_level_delete('ALL').delete_values,l_oo(i).object);--ALL will hold the levels involved

Line 300: bsc_aw_md_api.get_bsc_olap_object(null,'recursive level',p_dim,'dimension',l_oo);

296: --
297: if nvl(bsc_aw_utility.get_parameter_value(p_dim_property,'recursive',','),'N')='Y' then
298: l_level:=l_oo(1).object;
299: l_oo.delete;
300: bsc_aw_md_api.get_bsc_olap_object(null,'recursive level',p_dim,'dimension',l_oo);
301: for i in 1..l_oo.count loop
302: bsc_aw_utility.merge_value(p_dim_level_delete('ALL').delete_values,l_oo(i).object);--ALL will hold the levels involved
303: load_delete_dim_level_value(l_oo(i).object,upper(l_level),p_dim_level_delete);
304: end loop;

Line 406: bsc_aw_md_api.get_dim_for_level(p_dim_level_list(i),l_dim);

402: l_dim_list dbms_sql.varchar2_table;
403: l_dim varchar2(300);
404: Begin
405: for i in 1..p_dim_level_list.count loop
406: bsc_aw_md_api.get_dim_for_level(p_dim_level_list(i),l_dim);
407: if bsc_aw_utility.in_array(l_dim_list,l_dim)=false then
408: l_dim_list(l_dim_list.count+1):=l_dim;
409: end if;
410: end loop;

Line 436: bsc_aw_md_api.get_kpi_for_dim(p_dim,l_kpi_list);

432: end if;
433: --get lock, for purge, we need exclusive locks. otherwise we cannot delete dimensions
434: bsc_aw_management.get_workspace_lock('rw',null);
435: --purge kpi
436: bsc_aw_md_api.get_kpi_for_dim(p_dim,l_kpi_list);
437: for i in 1..l_kpi_list.count loop
438: bsc_aw_load_kpi.purge_kpi(l_kpi_list(i));
439: end loop;
440: --

Line 441: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_olap_object);

437: for i in 1..l_kpi_list.count loop
438: bsc_aw_load_kpi.purge_kpi(l_kpi_list(i));
439: end loop;
440: --
441: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_olap_object);
442: --purge variables
443: for i in 1..l_olap_object.count loop
444: if l_olap_object(i).object_type='limit cube' or l_olap_object(i).object_type='filter cube' then
445: bsc_aw_dbms_aw.execute('clear all from '||l_olap_object(i).olap_object);

Line 524: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,'dim limit cube',p_dim,'dimension',l_olap_object_relation);

520: l_kpi_reset_cubes dbms_sql.varchar2_table;
521: l_statlen varchar2(200);
522: l_relation varchar2(200);
523: Begin
524: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,'dim limit cube',p_dim,'dimension',l_olap_object_relation);
525: bsc_aw_md_api.get_bsc_olap_object(null,'relation',p_dim,'dimension',l_olap_object);
526: if l_olap_object.count>0 then
527: l_relation:=l_olap_object(1).olap_object;
528: else

Line 525: bsc_aw_md_api.get_bsc_olap_object(null,'relation',p_dim,'dimension',l_olap_object);

521: l_statlen varchar2(200);
522: l_relation varchar2(200);
523: Begin
524: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,'dim limit cube',p_dim,'dimension',l_olap_object_relation);
525: bsc_aw_md_api.get_bsc_olap_object(null,'relation',p_dim,'dimension',l_olap_object);
526: if l_olap_object.count>0 then
527: l_relation:=l_olap_object(1).olap_object;
528: else
529: if g_debug then

Line 624: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_bsc_olap_object);

620: l_kpi_aggregate_markers dbms_sql.varchar2_table;
621: l_objects dbms_sql.varchar2_table;
622: Begin
623: l_bsc_olap_object.delete;
624: bsc_aw_md_api.get_bsc_olap_object(null,null,p_dim,'dimension',l_bsc_olap_object);
625: for i in 1..l_bsc_olap_object.count loop
626: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
627: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
628: end if;

Line 698: bsc_aw_md_api.get_bsc_olap_object(p_dim,'dimension',p_dim,'dimension',l_oo);

694: function check_dim_loaded(p_dim varchar2) return varchar2 is
695: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
696: Begin
697: if bsc_aw_utility.in_array(bsc_aw_adapter_dim.get_preloaded_dim_list,p_dim)=false then
698: bsc_aw_md_api.get_bsc_olap_object(p_dim,'dimension',p_dim,'dimension',l_oo);
699: if l_oo(1).operation_flag is not null and l_oo(1).operation_flag='loaded' then
700: return 'Y';
701: else
702: return 'N';

Line 715: bsc_aw_md_api.update_olap_object(p_dim,'dimension',p_dim,'dimension',null,null,'operation_flag','loaded');

711:
712: procedure mark_dim_loaded(p_dim varchar2) is
713: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
714: Begin
715: bsc_aw_md_api.update_olap_object(p_dim,'dimension',p_dim,'dimension',null,null,'operation_flag','loaded');
716: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
717: for i in 1..l_oo.count loop --mark snowflake impl as loaded
718: bsc_aw_md_api.update_olap_object(l_oo(i).object,'dimension',l_oo(i).object,'dimension',null,null,'operation_flag','loaded');
719: end loop;

Line 716: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);

712: procedure mark_dim_loaded(p_dim varchar2) is
713: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
714: Begin
715: bsc_aw_md_api.update_olap_object(p_dim,'dimension',p_dim,'dimension',null,null,'operation_flag','loaded');
716: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
717: for i in 1..l_oo.count loop --mark snowflake impl as loaded
718: bsc_aw_md_api.update_olap_object(l_oo(i).object,'dimension',l_oo(i).object,'dimension',null,null,'operation_flag','loaded');
719: end loop;
720: Exception when others then

Line 718: bsc_aw_md_api.update_olap_object(l_oo(i).object,'dimension',l_oo(i).object,'dimension',null,null,'operation_flag','loaded');

714: Begin
715: bsc_aw_md_api.update_olap_object(p_dim,'dimension',p_dim,'dimension',null,null,'operation_flag','loaded');
716: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
717: for i in 1..l_oo.count loop --mark snowflake impl as loaded
718: bsc_aw_md_api.update_olap_object(l_oo(i).object,'dimension',l_oo(i).object,'dimension',null,null,'operation_flag','loaded');
719: end loop;
720: Exception when others then
721: log_n('Exception in mark_dim_loaded '||sqlerrm);
722: raise;

Line 733: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',null,'dimension',l_oo);

729: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
730: l_dim varchar2(200);
731: l_dim_list dbms_sql.varchar2_table;
732: Begin
733: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',null,'dimension',l_oo);
734: for i in 1..l_oo.count loop
735: if bsc_aw_utility.get_parameter_value(l_oo(i).property1,'periodicity',',') is null then --this is not a calendar dim level
736: bsc_aw_md_api.get_dim_for_level(l_oo(i).object,l_dim);
737: bsc_aw_utility.merge_value(l_dim_list,l_dim);

Line 736: bsc_aw_md_api.get_dim_for_level(l_oo(i).object,l_dim);

732: Begin
733: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',null,'dimension',l_oo);
734: for i in 1..l_oo.count loop
735: if bsc_aw_utility.get_parameter_value(l_oo(i).property1,'periodicity',',') is null then --this is not a calendar dim level
736: bsc_aw_md_api.get_dim_for_level(l_oo(i).object,l_dim);
737: bsc_aw_utility.merge_value(l_dim_list,l_dim);
738: end if;
739: end loop;
740: --

Line 758: bsc_aw_md_api.get_bsc_olap_object(p_dim,'dimension',p_dim,'dimension',l_oo);

754: if g_debug then
755: log('upgrade_load_sync_all_dim '||p_dim);
756: end if;
757: /*add delete values into the dim levels */
758: bsc_aw_md_api.get_bsc_olap_object(p_dim,'dimension',p_dim,'dimension',l_oo);
759: if l_oo.count>0 then
760: load_dim_delete(p_dim,l_oo(1).property1,l_dim_level_delete,l_delete_flag);
761: if l_delete_flag then
762: merge_delete_values_to_levels(l_dim_level_delete);

Line 767: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',p_dim,'dimension',l_oo);

763: end if;
764: end if;
765: /*refresh the dim */
766: l_oo.delete;
767: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',p_dim,'dimension',l_oo);
768: for i in 1..l_oo.count loop
769: if l_oo(i).olap_object_type='dml program initial load' then
770: begin
771: bsc_aw_dbms_aw.execute('call '||l_oo(i).object);