[Home] [Help]
31: p_dimension varchar2
32: ) return boolean;
33: procedure get_kpi_for_dim(
34: p_dim_name varchar2,
35: p_kpi_list out nocopy dbms_sql.varchar2_table
36: );
37: procedure mark_kpi_recreate(p_kpi varchar2);
38: procedure get_dim_olap_objects(
39: p_dim_name varchar2,
42: );
43: procedure drop_dim(p_dim_name varchar2);
44: procedure get_ccdim_for_levels(
45: p_dimension bsc_aw_adapter_dim.dimension_r,
46: p_dim_list out nocopy dbms_sql.varchar2_table
47: );
48: procedure create_dim_objects(
49: p_dimension bsc_aw_adapter_dim.dimension_r
50: );
77: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
78: );
79: procedure get_dim_for_kpi(
80: p_kpi varchar2,
81: p_dim_list out nocopy dbms_sql.varchar2_table
82: );
83: procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r);
84: procedure get_dim_properties(p_dim in out nocopy bsc_aw_adapter_kpi.dim_r);
85: procedure get_dim_set_calendar(
176: procedure drop_bt_change_vector(p_base_table varchar2);
177: procedure get_relation_object(
178: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,
179: p_relation_type varchar2,
180: p_relation_object in out nocopy dbms_sql.varchar2_table
181: );
182: procedure get_dimset_comp_PT(
183: p_kpi varchar2,
184: p_dimset_name varchar2,
225: p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
226: );
227: procedure clear_all_cache;
228: procedure get_dim_md(p_dim_name varchar2,p_dimension out nocopy bsc_aw_adapter_dim.dimension_r);
229: procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table);
230: procedure analyze_md_tables;
231: procedure get_kpi(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r);
232: procedure update_bt_current_period(p_base_table varchar2,p_value varchar2);
233: function get_bt_current_period(p_base_table varchar2) return varchar2;