DBA Data[Home] [Help]

APPS.BSC_AW_LOAD_DIM dependencies on BSC_OLAP_OBJECT_RELATION

Line 515: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

511: we also set the aggregate marker for the kpi dimset to true
512: */
513: procedure set_kpi_limit_variables(p_dim varchar2) is
514: --
515: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
516: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
517: l_dim_limit_cube varchar2(300);
518: l_kpi_limit_cubes dbms_sql.varchar2_table;
519: l_kpi_aggregate_markers dbms_sql.varchar2_table;

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