Two Advanced Filtering Techniques Improve Performance

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • November 1, 2003
Filtering data allows you to execute queries against smaller datasets and boost performance. The author describes two techniques for doing so that are not commonly used: filtering records coming out of R/3 and filtering in update or transfer rules. Both require ABAP code, but offer the ability to use more complex selection criteria.

 

You have two less-commonly-used options for data filtering that might meet your requirements:

  • Filter records coming out of R/3. This technique takes advantage of an ABAP user exit to filter or flag data on the R/3 source system.
  • Filter in the update or transfer rules. Filters are applied during the loading process, and they allow for selection of data using ABAP code.

Although both methods require that you or an ABAPer on your team write code, they are relatively easy to set up. I’ll tell you when to use each option and show you how to carry out each one.

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.