[Home] [Help]
149: we consider time and other dim separately. time is considered in calendars, not in dim
150:
151: here we are getting level properties in 2 parts.
152: bsc_aw_bsc_metadata.get_dim_level_properties gets it from metadata
153: for rec dim, we also do bsc_aw_md_api.get_bsc_olap_object_relation to find the rec_parent_level.
154: this is ok since rec_parent_level is not a bsc metadata property. its specific to our implementation.
155: */
156: procedure get_dim_set_dim_properties(p_kpi varchar2,p_dim_set in out nocopy dim_set_r) is
157: Begin
166: End;
167:
168: procedure get_dim_properties(p_kpi varchar2,p_dim in out nocopy dim_r) is
169: --
170: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
171: Begin
172: bsc_aw_md_api.get_dim_properties(p_dim); --recursive, multi level, time or normal, concat?, base value cube etc
173: bsc_aw_bsc_metadata.get_dim_level_properties(p_kpi,p_dim); --pk,fk,datatype for the levels and the filter
174: l_olap_object_relation.delete;
172: bsc_aw_md_api.get_dim_properties(p_dim); --recursive, multi level, time or normal, concat?, base value cube etc
173: bsc_aw_bsc_metadata.get_dim_level_properties(p_kpi,p_dim); --pk,fk,datatype for the levels and the filter
174: l_olap_object_relation.delete;
175: --'zero code level' 'recursive parent level'
176: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_dim.dim_name,'dimension',l_olap_object_relation);
177: for i in 1..l_olap_object_relation.count loop
178: if l_olap_object_relation(i).object_type='dimension level' and l_olap_object_relation(i).relation_type='zero code level' then
179: for j in 1..p_dim.levels.count loop
180: if l_olap_object_relation(i).object=p_dim.levels(j).level_name then
213: raise;
214: End;
215:
216: procedure set_dim_level_positions(p_dim in out nocopy dim_r) is
217: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
218: Begin
219: l_olap_object.delete;
220: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim.dim_name,'dimension',l_olap_object);
221: for i in 1..p_dim.levels.count loop
216: procedure set_dim_level_positions(p_dim in out nocopy dim_r) is
217: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
218: Begin
219: l_olap_object.delete;
220: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim.dim_name,'dimension',l_olap_object);
221: for i in 1..p_dim.levels.count loop
222: --standalone dim for each dim level do not have dimension levels with them.
223: p_dim.levels(i).position:=1;
224: for j in 1..l_olap_object.count loop
481:
482: procedure set_dim_set_data_source(p_kpi kpi_r,p_dim_set in out nocopy dim_set_r) is
483: Begin
484: /*
485: get the change vector value. we look at bsc_olap_object_relation to see what change vectors are currently
486: used for base tables. then we allocate the next higher number
487: get_change_vector sets the change vector for initial, inc and target data sources
488:
489: we have obsoleted the old approach to inc load as mentioned above . (date today is 18 may 2005)
1574: raise;
1575: End;
1576:
1577: /*
1578: we will hold the type and view name in bsc olap objects. olap_object column will be null. so
1579: drop_kpi_objects_relational action is final. due to database commit, if there is a failure in between, we cannot guarantee
1580: the system. drop has to be rerun till successful
1581: */
1582: procedure drop_kpi_objects_relational(p_kpi varchar2) is
1580: the system. drop has to be rerun till successful
1581: */
1582: procedure drop_kpi_objects_relational(p_kpi varchar2) is
1583: l_flag dbms_sql.varchar2_table;
1584: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1585: Begin
1586: bsc_aw_md_api.get_bsc_olap_object(null,null,p_kpi,'kpi',l_olap_object);
1587: for i in 1..l_olap_object.count loop
1588: l_flag(i):='N';
1582: procedure drop_kpi_objects_relational(p_kpi varchar2) is
1583: l_flag dbms_sql.varchar2_table;
1584: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1585: Begin
1586: bsc_aw_md_api.get_bsc_olap_object(null,null,p_kpi,'kpi',l_olap_object);
1587: for i in 1..l_olap_object.count loop
1588: l_flag(i):='N';
1589: end loop;
1590: --
4340: log_n('Exception in set_dim_agg_level '||sqlerrm);
4341: raise;
4342: End;
4343:
4344: /*level positions are read from bsc_olap_object. level positions are set when the dim metadata is created. so the lowest level for a kpi
4345: need not have level position of 1 */
4346: procedure set_dim_agg_level(p_dim_set in out nocopy dim_set_r) is
4347: Begin
4348: for i in 1..p_dim_set.dim.count loop
4628: p_dim_levels dbms_sql.varchar2_table,
4629: p_name varchar2,
4630: p_table_name varchar2) is
4631: --
4632: l_oo_object bsc_aw_md_wrapper.bsc_olap_object_tb;
4633: l_oo_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
4634: l_dimset varchar2(100);
4635: l_dim_level_dims dbms_sql.varchar2_table;
4636: l_measures dbms_sql.varchar2_table;
4629: p_name varchar2,
4630: p_table_name varchar2) is
4631: --
4632: l_oo_object bsc_aw_md_wrapper.bsc_olap_object_tb;
4633: l_oo_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
4634: l_dimset varchar2(100);
4635: l_dim_level_dims dbms_sql.varchar2_table;
4636: l_measures dbms_sql.varchar2_table;
4637: l_cubes dbms_sql.varchar2_table;
4652: end if;
4653: end if;
4654: end loop;
4655: if l_dimset is not null then
4656: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_oo_relation);
4657: for i in 1..l_dim_levels.count loop
4658: l_dim_level_dims(i):=null;
4659: for j in 1..l_oo_relation.count loop
4660: if l_oo_relation(j).relation_object=l_dim_levels(i) and l_oo_relation(j).relation_type='dim set dim level' and
4665: end if;
4666: end loop;
4667: --is this rec dim, then get the parent level
4668: l_oo_object.delete;
4669: bsc_aw_md_api.get_bsc_olap_object(l_dim_level_dims(i),'dimension',l_dim_level_dims(i),'dimension',l_oo_object);
4670: if bsc_aw_utility.get_parameter_value(l_oo_object(1).property1,'recursive',',')='Y' then
4671: l_oo_object.delete;
4672: bsc_aw_md_api.get_bsc_olap_object(null,'recursive level',l_dim_level_dims(i),'dimension',l_oo_object);
4673: l_dim_levels(i):=l_oo_object(1).object;--store the parent rec level
4668: l_oo_object.delete;
4669: bsc_aw_md_api.get_bsc_olap_object(l_dim_level_dims(i),'dimension',l_dim_level_dims(i),'dimension',l_oo_object);
4670: if bsc_aw_utility.get_parameter_value(l_oo_object(1).property1,'recursive',',')='Y' then
4671: l_oo_object.delete;
4672: bsc_aw_md_api.get_bsc_olap_object(null,'recursive level',l_dim_level_dims(i),'dimension',l_oo_object);
4673: l_dim_levels(i):=l_oo_object(1).object;--store the parent rec level
4674: end if;
4675: end loop;
4676: --calendar