12 Tips to Automate BW Using Process Chains

  • by Craig Handjian, BW Consultant
  • November 1, 2003
Process chains are the new generation (as of BW 3.0) of job scheduling and monitoring tools for tasks such as data loads, Reporting Agent jobs, or index rebuilds. The author recently automated a large BW system using process chains, and these 12 tips will get you started on your own automation project.


Those of you responsible for data-target administration and data-load monitoring probably have tasks that you would like to automate such as transactional and master data loads, Reporting Agent jobs, or index and statistic rebuilds. With BW 3.x’s new process chain functionality, batch automation is easier to set up and manage. Process chains form the building blocks for the next generation of job scheduling and monitoring tools within BW.

During the past 10 months, I have used process chains extensively to automate a large, 24-by-7 global BW system, and I have compiled a laundry list of lessons learned. I’ve grouped these lessons into four categories, which mimic a modified version of the system-development lifecycle. The four categories include analysis, design, build and test, and support. The 12 tips I present here will help you productively work through the analysis phase. To take full advantage of the tips, you should be using BW 3.0B or higher and Support Package 13, which offers a number of process chain enhancements.

Craig Handjian

Craig Handjian is a BW consultant. He has been working with supply chain management software solutions for the past five years, with three of those years dedicated to SAP BW. During these three years, he has worked with everything from Basis and security to back- and front-end development.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.