[Home] [Help]
193: l_model varchar2(16000);
194: l_olapCmd varchar2(1000);
195: begin
196:
197: zpb_log.write ('zpb_olap_views_pkg.call_ddl.begin',
198: 'Creating '||p_dimView||' structures');
199:
200: if (p_aw <> 'PERSONAL' and p_aw <> 'EXPRESS' and instr(p_aw, '.') = 0) then
201: l_aw := zpb_aw.get_schema||'.'||p_aw;
205:
206: --
207: -- Build object
208: --
209: zpb_log.write_statement ('zpb_olap_views_pkg.call_ddl',
210: 'Executing: '||p_objComm);
211:
212: execute immediate 'create type '||l_dimObj||' as '||p_objComm;
213:
242: ' DURATION SESSION'', '''|| l_schemaName || '.' || l_dimTable||
243: ''', '''||l_olapCmd||''', '||p_lmap||') AS '||l_dimTable||'))'||
244: l_model;
245:
246: zpb_log.write ('zpb_build_metadata.call_ddl.end',
247: 'Finished creating '||p_dimView||' structures');
248: end CALL_DDL;
249:
250: -------------------------------------------------------------------------------
343: l_global_ecm zpb_ecm.global_ecm;
344: l_attr_ecm zpb_ecm.global_attr_ecm;
345:
346: begin
347: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.begin',
348: 'Begin create_attribute_views');
349: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
350: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
351: l_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
420:
421: exit when j = 0;
422: end loop;
423:
424: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.end',
425: 'End create_attribute_views');
426:
427: end CREATE_ATTRIBUTE_VIEWS;
428:
645: DROP_VIEW (l_relView);
646: CALL_DDL (l_relView, p_aw, l_statement||')', l_lmap, l_cols);
647: end if;
648:
649: zpb_log.write ('zpb_olap_views_pkg.create_cube_view.end',
650: 'End create_cube_view');
651:
652: end CREATE_CUBE_VIEW;
653:
700: l_dim_ecm zpb_ecm.dimension_ecm;
701: l_dim_data zpb_ecm.dimension_data;
702:
703: begin
704: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.begin',
705: 'Begin create_dimension_views');
706: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
707: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
708:
922: ZPB_AW.EXECUTE ('call DB.BUILD.LMAP ('''||zpb_aw.get_schema||'.'||
923: p_aw||''')');
924: ZPB_AW.EXECUTE ('pop oknullstatus');
925:
926: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.end',
927: 'End create_dimension_views');
928:
929: end CREATE_DIMENSION_VIEWS;
930:
970: l_dim_data zpb_ecm.dimension_data;
971:
972: begin
973:
974: zpb_log.write ('zpb_olap_views_pkg.create_security_views.begin',
975: 'Building '||p_measures||' for view '||p_measView||
976: ' with dims ('||p_dims||')');
977:
978: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
999: l_measName := 'SECOWNMAP2.F';
1000: l_measCol := zpb_metadata_names.get_ownermap_column;
1001: l_measType := 'VARCHAR2(8)';
1002: else
1003: ZPB_LOG.WRITE ('zpb_olap_view_pkg.create_security_views',
1004: 'Invalid measure type: '||l_measure);
1005: return;
1006: end if;
1007:
1096: l_cols := substr(l_cols, 1, length(l_cols)-1);
1097: l_measProc := ''''||l_measProc||'''';
1098:
1099: call_ddl (p_measView, p_aw, l_measState, l_measProc, l_cols);
1100: zpb_log.write ('zpb_olap_views_pkg.create_security_views.end',
1101: 'End create_security_views');
1102:
1103: end CREATE_SECURITY_VIEW;
1104:
1140: l_global_ecm zpb_ecm.global_ecm;
1141: l_dim_ecm zpb_ecm.dimension_ecm;
1142: l_dim_data zpb_ecm.dimension_data;
1143: begin
1144: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.begin',
1145: 'Building AW metadata views');
1146:
1147: l_global_ecm := zpb_ecm.get_global_ecm (p_dataAw);
1148: l_schema := zpb_aw.get_schema;
1299: drop_view (l_view);
1300: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');
1301: end if;
1302:
1303: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.end',
1304: 'Done building AW metadata views');
1305: end CREATE_VIEW_STRUCTURES;
1306:
1307: -------------------------------------------------------------------------------