eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_OLAP_PVT dependencies on DBMS_CUBE

Line 177: DBMS_CUBE.BUILD('

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),

Line 199: dbms_cube_log.table_create(dbms_cube_log.type_build);

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:

Line 200: dbms_cube_log.table_create(dbms_cube_log.type_operations);

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)',

Line 201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);

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)

Line 204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',

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

Line 212: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',

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

Line 232: dbms_cube_log.table_create(dbms_cube_log.type_build);

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:

Line 233: dbms_cube_log.table_create(dbms_cube_log.type_operations);

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)',

Line 234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);

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

Line 237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',

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

Line 246: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',

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

Line 270: dbms_cube.import_xml( to_clob(

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:

Line 4401: dbms_cube.import_xml(v_xml_clob);

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;