Skip to Content
Former Member
Feb 07, 2007 at 10:00 PM

performance problem with UPC_BUNDLE_EXECUTE_STEP


I am trying to use UPC_BUNDLE_EXECUTE_STEP program to execute global planning sequence to copy data from actual's cube to plan cube. I followed the steps in OSS note 546464. For the partition characteristics, I give the rebate number and from & to range.

When I execute the program in the back ground, it takes close to an hour in our development box. If I run the planning function in BPS0, it completes in 5 minutes. In our quality, if I split the range in the BPS0, I am able to get the data loaded in 2 hours for all rebates. Using UPC_BUNDLE_EXECUTE_STEP , ran for 2 days and did not complete.

Is there anything that I needed to do the speed up the processing.


VJ Sudharsan