[Home] [Help]
19: if g_workspace_attached is null or g_workspace_attached=false then
20: attach_workspace;
21: end if;
22: Exception when others then
23: bsc_aw_management.detach_workspace;
24: g_workspace_attached:=false;
25: log_n('Exception in init_filters '||sqlerrm);
26: raise;
27: End;
196: --limit the dim to the composites if we have ALL
197: limit_dim_to_composite(g_kpi(l_kpi).dim_set(p_dim_set),l_parameters);
198: --UI can now query from olap table function view
199: Exception when others then
200: bsc_aw_management.detach_workspace;
201: g_workspace_attached:=false;
202: log_n('Exception in limit_dimensions '||sqlerrm);
203: raise;
204: End;
1462: procedure attach_workspace is
1463: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1464: Begin
1465: begin
1466: bsc_aw_management.get_workspace_lock('ro',null); --read only mode
1467: exception when others then
1468: if sqlcode=-33262 then
1469: --ignore this error. this may be a MV instance
1470: null;
1480:
1481: procedure detach_workspace is
1482: Begin
1483: begin
1484: bsc_aw_management.detach_workspace;
1485: exception when others then
1486: if sqlcode=-33262 then
1487: --ignore this error. this may be a MV instance
1488: null;
1591: end if;
1592: bsc_aw_utility.init_all(g_debug);
1593: BSC_AW_MD_API.init_all;
1594: bsc_aw_dbms_aw.init_all;
1595: bsc_aw_management.init_all;
1596: g_std_dim:=bsc_aw_adapter_dim.get_std_dim_list;
1597: if nvl(bsc_aw_utility.get_parameter_value('FILE LOG'),'N')='Y' then
1598: g_log_type:='file log';
1599: else