[Home] [Help]
536: /*given a calendar name, it reads cal info from olap metadata. NOTE...not all info is read
537: */
538: procedure get_calendar(p_calendar_name varchar2,p_calendar out nocopy calendar_r) is
539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);
544: --
539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);
544: --
545: p_calendar.dim_name:=p_calendar_name;
546: for i in 1..l_oo.count loop
547: if l_oo(i).object=p_calendar_name and l_oo(i).object_type='dimension' then
921: right now, see if there are new periodicities or dropped periodicities
922: */
923: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2) is
924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);
929: l_olap_periodicity_dim dbms_sql.varchar2_table;
930: l_pc parent_child_tb;
931: --
932: Begin
933: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar.dim_name,'dimension',l_oo);
934: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar.dim_name,'dimension',l_oor);
935: if l_oo.count=0 then
936: return;
937: end if;
938: for i in 1..p_calendar.periodicity.count loop