Improve APO Load Performance with Three Advanced Filtering Techniques

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • December 1, 2003
ou probably don’t need to use all the data in your APO source system for your BW-generated demand planning reports. Filtering that data so your query uses only what’s relevant will boost performance. Learn about three methods for carrying out this filtering: filtering in the source system, using the InfoPackage selection criteria, and filtering in update or transfer rules.

Companies that have been using BW or R/3 for a long time typically have large volumes of data in their APO source systems. A portion of this data is often not relevant for APO Demand Planning, as planning is not necessary for all customers or materials. In many cases, a small subset of the larger source dataset is actually loaded to APO.

To keep APO populated with the proper data needed for planning, filters need to be applied to the data. The simple selection criteria available via the InfoPackage Select data tab (Figure 1) is sometimes not enough to properly segregate the data. Instead, you need complex filters to segregate data when loading from R/3 to APO, BW to APO, or even to InfoCubes within APO.


Figure 1
Selection criteria in the InfoPackage Select data tab

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

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.