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_MD_API

Line 575: if bsc_aw_md_api.is_dim_present(p_dimension.dim_name)=false then

571: else
572: if g_debug then
573: log('This is std dim. Check to see if dim exists...');
574: end if;
575: if bsc_aw_md_api.is_dim_present(p_dimension.dim_name)=false then
576: l_dim_create:='create all';
577: end if;
578: end if;
579: --

Line 620: bsc_aw_md_api.get_kpi_for_dim(p_dim_name,l_kpi_list);

616: l_kpi_list dbms_sql.varchar2_table;
617: --
618: Begin
619: --get_kpi_for_dim gives the list of kpi already implemented in AW for this dim
620: bsc_aw_md_api.get_kpi_for_dim(p_dim_name,l_kpi_list);
621: bsc_aw_utility.merge_array(p_affected_kpi,l_kpi_list);
622: for i in 1..l_kpi_list.count loop
623: bsc_aw_adapter_kpi.drop_kpi_objects(l_kpi_list(i));
624: bsc_aw_md_api.mark_kpi_recreate(l_kpi_list(i));

Line 624: bsc_aw_md_api.mark_kpi_recreate(l_kpi_list(i));

620: bsc_aw_md_api.get_kpi_for_dim(p_dim_name,l_kpi_list);
621: bsc_aw_utility.merge_array(p_affected_kpi,l_kpi_list);
622: for i in 1..l_kpi_list.count loop
623: bsc_aw_adapter_kpi.drop_kpi_objects(l_kpi_list(i));
624: bsc_aw_md_api.mark_kpi_recreate(l_kpi_list(i));
625: end loop;
626: Exception when others then
627: log_n('Exception in drop_kpi_objects_for_dim '||sqlerrm);
628: raise;

Line 644: bsc_aw_md_api.get_dim_olap_objects(p_dim_name,l_objects,'all');

640: l_objects bsc_aw_md_wrapper.bsc_olap_object_tb;
641: l_flag dbms_sql.varchar2_table;
642: --
643: Begin
644: bsc_aw_md_api.get_dim_olap_objects(p_dim_name,l_objects,'all');
645: for i in 1..l_objects.count loop
646: if l_objects(i).olap_object_type is null then
647: l_flag(i):='Y';
648: else

Line 682: bsc_aw_md_api.drop_dim(p_dim_name);--this will delete all child objects in metadata

678: bsc_aw_utility.delete_aw_object(l_objects(i).object);
679: l_flag(i):='Y';
680: end if;
681: end loop;
682: bsc_aw_md_api.drop_dim(p_dim_name);--this will delete all child objects in metadata
683: Exception when others then
684: log_n('Exception in drop_dim '||sqlerrm);
685: raise;
686: End;

Line 702: bsc_aw_md_api.get_ccdim_for_levels(p_dimension,l_dim_list);

698: --its best to have same structure for all dim. single level dim also have concat dimensions
699: if g_debug then
700: log('In drop_old_dim_for_level '||p_dimension.dim_name);
701: end if;
702: bsc_aw_md_api.get_ccdim_for_levels(p_dimension,l_dim_list);
703: if g_debug then
704: for i in 1..l_dim_list.count loop
705: log('Old CC Dim to be dropped are '||l_dim_list(i));
706: end loop;

Line 746: bsc_aw_md_api.create_dim_objects(p_dimension);

742: --bug fix 5636695
743: -- calling this api here will fill the correct values in property attribute
744: -- including level name dim
745: set_dim_properties(p_dimension);
746: bsc_aw_md_api.create_dim_objects(p_dimension);
747: bsc_aw_utility.remove_sqlerror(-34340,'ignore');
748: bsc_aw_utility.remove_sqlerror(-36656,'ignore');
749: Exception when others then
750: log_n('Exception in create_dim_objects '||sqlerrm);

Line 1632: bsc_aw_md_api.get_bsc_olap_object_relation(p_dim,'dimension',null,null,null,l_olap_object_relation);

1628: --
1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1630: Begin
1631: l_olap_object_relation.delete;
1632: bsc_aw_md_api.get_bsc_olap_object_relation(p_dim,'dimension',null,null,null,l_olap_object_relation);
1633: for i in 1..l_olap_object_relation.count loop
1634: --do this only if the limit cube is "actual" limit cube. not if its target limit cube
1635: if bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'dim set type',',')='actual' then
1636: if l_olap_object_relation(i).relation_type='kpi limit cube' then

Line 1704: bsc_aw_md_api.get_ccdim_for_levels(p_dim,l_old_dim_list);

1700: log('correct_old_dim for '||p_dim.dim_name);
1701: end if;
1702: p_flag:='create all';
1703: l_new_dim:=p_dim;
1704: bsc_aw_md_api.get_ccdim_for_levels(p_dim,l_old_dim_list);
1705: if l_old_dim_list.count>0 then
1706: for i in 1..l_old_dim_list.count loop
1707: bsc_aw_md_api.get_dim_md(l_old_dim_list(i),l_old_dim(i));
1708: if g_debug then

Line 1707: bsc_aw_md_api.get_dim_md(l_old_dim_list(i),l_old_dim(i));

1703: l_new_dim:=p_dim;
1704: bsc_aw_md_api.get_ccdim_for_levels(p_dim,l_old_dim_list);
1705: if l_old_dim_list.count>0 then
1706: for i in 1..l_old_dim_list.count loop
1707: bsc_aw_md_api.get_dim_md(l_old_dim_list(i),l_old_dim(i));
1708: if g_debug then
1709: log('Old dim dmp');
1710: dmp_dimension(l_old_dim(i));
1711: end if;

Line 1797: bsc_aw_md_api.drop_dim(p_old_dim.dim_name);

1793: if g_debug then
1794: log('After correct levels,zero levels,parent child,level name dim and level groups');
1795: dmp_dimension(p_old_dim);
1796: end if;
1797: bsc_aw_md_api.drop_dim(p_old_dim.dim_name);
1798: create_dim_program(p_old_dim);
1799: bsc_aw_md_api.create_dim_objects(p_old_dim);
1800: Exception when others then
1801: log_n('Exception in correct_dim '||sqlerrm);

Line 1799: bsc_aw_md_api.create_dim_objects(p_old_dim);

1795: dmp_dimension(p_old_dim);
1796: end if;
1797: bsc_aw_md_api.drop_dim(p_old_dim.dim_name);
1798: create_dim_program(p_old_dim);
1799: bsc_aw_md_api.create_dim_objects(p_old_dim);
1800: Exception when others then
1801: log_n('Exception in correct_dim '||sqlerrm);
1802: raise;
1803: End;

Line 1882: bsc_aw_md_api.drop_dim(p_old_dim.dim_name);--drop metadata

1878: end if;
1879: end loop;
1880: end loop;
1881: --
1882: bsc_aw_md_api.drop_dim(p_old_dim.dim_name);--drop metadata
1883: create_dim_objects(p_new_dim);--creates objects and metadata
1884: Exception when others then
1885: log_n('Exception in merge_dim '||sqlerrm);
1886: raise;

Line 2296: if bsc_aw_md_api.is_dim_present(p_dimension.dim_name)=false then --no name conflict

2292: if l_count>bsc_aw_utility.g_infinite_loop then
2293: log('Infinite loop detected in check_dim_name_conflict');
2294: raise bsc_aw_utility.g_exception;
2295: end if;
2296: if bsc_aw_md_api.is_dim_present(p_dimension.dim_name)=false then --no name conflict
2297: exit;
2298: end if;
2299: l_count:=l_count+1;
2300: make_dim_name(p_dimension,get_dim_name_hash_string(p_dimension)||'.'||bsc_aw_utility.get_dbms_time);

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

2451: /*if any level is view based, return Y*/
2452: function check_dim_view_based(p_dim varchar2) return varchar2 is
2453: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
2454: Begin
2455: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
2456: for i in 1..l_oo.count loop
2457: if bsc_aw_utility.get_parameter_value(l_oo(i).property1,'level source',',')='view' then
2458: return 'Y';
2459: end if;