173: as
174:
175: begin
176:
177: DBMS_CUBE.BUILD('
178: "PA_CALENDAR_TYPE" USING (LOAD NO SYNCH, COMPILE SORT),
179: "PA_CBS_ELEMENTS_DM" USING (LOAD NO SYNCH, COMPILE SORT),
180: "PA_CBS_VERSIONS_DM" USING (LOAD NO SYNCH, COMPILE SORT),
181: "PA_CURRENCY_DM" USING (LOAD NO SYNCH, COMPILE SORT),
195: begin
196:
197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
196:
197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
205: 'S', -- FAST SOLVE (incremental solve)
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
205: 'S', -- FAST SOLVE (incremental solve)
206: false, -- refresh after errors
207: 6, -- parallelism
208: true, -- atomic refresh
208: true, -- atomic refresh
209: true, -- automatic order
210: false); -- add dimensions
211:
212: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
213: 'S', -- FAST SOLVE (incremental solve)
214: false, -- refresh after errors
215: 6, -- parallelism
216: true, -- atomic refresh
228: begin
229:
230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
229:
230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
238: 'C', -- COMPLETE refresh
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
238: 'C', -- COMPLETE refresh
239: false, -- refresh after errors
240: 7, -- parallelism
241: true, -- atomic refresh
242: true, -- automatic order
243: false); -- add dimensions
244:
245:
246: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
247: 'C', -- COMPLETE refresh
248: false, -- refresh after errors
249: 7, -- parallelism
250: true, -- atomic refresh
266: where aw_name = 'PA_PPR_AW';
267:
268: if ( aw_count > 0 ) then
269:
270: dbms_cube.import_xml( to_clob(
271: '
272:
273:
274:
4397:
4398:
4399: dbms_lob.close(v_xml_clob);
4400: --dbms_output.put_line(v_xml_clob);
4401: dbms_cube.import_xml(v_xml_clob);
4402:
4403: end ;
4404:
4405: end PA_olap_PVT;