Pointers for optimizing system performance (run time) while running DP process chain with parallel processing

[sourabh_jain9]

Hi Experts,

We are running APO DP process chain with parallel processing in our company, we are experiencing some issues regarding run time of process chain, need your help on below points;

- What are the ways we can optimize process chain run time.

- Special points we need to take care of in case of parallel processing profiles used in process chain.

- Any specific sequence to be followed for different processes in process chain - if there is some best practice followed.

- Any notes suggesting ways to improve system performance for APO version 7 with different enhancement packs 1 and 2.

Any help will be really appreciated.

Regards

[jagannadhb · Accepted solution]

Hi Neelesh,

Following are some points I can think of:

• Try to reduce the data that is being loaded (if it is related to BW objects).
• Try deleting obsolete CVCs, to reduce the run time
• For attribute change runs (activating infoobjects/other BW objects), try reducing the obsolete data
• For all calculated keyfigures it is advisable to reset them before re-calculating. While resetting (initializing) make sure it is done at an aggregated level to reduce run time
• Try to split a single step into multiple steps based on product group etc and run in parallel.
• Scheduling a process chain based on dependencies might take longer than including in one meta chain (you can group similar process chains together), if you don't have a scheduler

Regards

JB

[sourabh_jain9 · Accepted solution]

Hi JB,

Thanks a lot for your suggestions, i will check and get back to you for any further questions.

Rgds

NB

[Former Member]

Hi Neelesh,

Please check in your macros's that selection ID's don't have any Wild card entries. If its there this will take longer time. Also the Selection ID and the aggregation in Macro job should be in sync. Now for Parallel processings, create different processes and check one by one. Also uncheck the Logs in Macro job.

Regards,

Anil

[sourabh_jain9]

Hi Anil,

Thanks a lot for your suggestions, i will check and get back to you for any further questions.

Rgds

NB

[sourabh_jain9]

Hi Experts,

Please somebody help me here, please let me know if you need further information on this.

Rgds

NB

[sourabh_jain9]

Can anybody please help me here, i have searched all google, but couldn't find answers for my questions.

Rgds

NB

[Former Member]

HI Neelesh,

There are many ways to optimize performance of the process chains (background jobs) in APO system.

Firstly I would recommend you to identify the pain areas (steps) which are completing with more runtimes. Then each one of the step has got different approaches to decrease the runtime.

Like you may end up with steps like infopackage executions, DTPs, DP mass processing jobs etc which might be running with more runtimes. So now target each one of them differently and find out the ways to optimize. At the same time the approach you follow should be technically possible with basis perspective (system load and utilization) as well.

And coming to parallel processing, you can use parallel processing for different for different jobs. You can further r explore on the same using parallel processing. Like loading an infocube, mass processing, infopackage execution, DTP, TSCOPY etc.

Check the below link for more info

Performance problems in DP mass processing

Let me know if you require further info.

Regards,

Raj

[sourabh_jain9]

Hi Raj,

Thanks a lot for your reply, i will check as per your suggestions and get back to you in case of further query.

Rgds

NB

[sourabh_jain9]

Hi Experts,

Can anybody please help me, really appreciate your help here.

Rgds

NB