Automate Your Loads with Recursive InfoPackages

  • by David Theroux-Benoni, Independent BW Consultant
  • May 1, 2004
Setting up InfoPackages for data loads is often a time-consuming process. Through examples, the author explains two time-saving ways to automate your InfoPackages. He also debates the benefits and drawbacks of each method, which will enable you to choose the best way for you to schedule your InfoPackages. Sample code is provided.

 

Using an InfoPackage that runs automatically can save you a lot of time when performing data load processes. So- called recursive InfoPackages can streamline your workload — especially during a BW cutover — and eliminate the need for multiple InfoPackages.

The concept of recursive InfoPackaging is simple. In table TVARVC, you set an initial date range. When the InfoPackage is launched, the date range is read from table TVARVC and updated with new dates for the next run. The same InfoPackage is called recursively using one of two methods, which I call domino triggering and time-interval scheduling.

Domino triggering causes a new load to start only if the previous load is fiished. The packets “fall” one after the other like dominos, which prevents the system from becoming bogged down because one load must finish before the next starts. Time-interval scheduling allows you to schedule loads at a prescribed amount of time, either minutes or hours. Loading starts along time intervals regardless of the status of the system or if the last load has finished.

To demonstrate the methods, I will detail a fictitious point-of-sale (POS) data cutover load from a legacy system with 52 million records for one year. This cutover could be performed in one load, but that could be a very long process. You could split the load into two-week packets, which would require you to create 26 similar InfoPackages and schedule them at different times. This setup may take you many hours and is prone to scheduling or date selection errors.

David Theroux-Benoni

David Theroux-Benoni is a BW and ABAP certified independent consultant. He has more than three years of practice with SAP Business Information Warehouse as well as six years of overall SAP experience in ABAP. He specializes in complex and massive data extraction projects from R/3, legacy applications, and software such as Agilisys DP, AP, and AS systems.

See more by this author


Comments

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.