22 Ways to Improve BW Back-End Performance

  • by Nurullah Battal, Turquoise Consulting
  • March 1, 2003
You have three key areas where you can boost BW performance on the back-end: the collection and extraction layer, the transformation layer, and the staging and storage layer. The author provides speed-up tips in all three of these areas.


Performance tuning of the BW back-end — the data model design and data flow across the model from the source system to the data targets — can produce real benefits. The goal of performance tuning on the back-end is to eliminate redundant processes and to reduce the volume of data to be processed during data upload from source systems to data targets.

You have three levels in the BW back-end to consider:

  • The collection and extraction layer
  • The transformation layer
  • The staging and storage layer

At my company, we have learned a number of tips for improving BW performance at these levels, and 22 of them follow.

Nurullah Battal

Nurullah Battal has several years' experience in enterprise business solutions, with an emphasis on MIS and DSS systems based on SAP solutions. He is experienced in all phases of design and implementation of the end-to-end analytical applications on data-warehousing solutions, especially SAP SEM components on BW. In addition, Nurullah has considerable experience with SAP BW, SEM BPS, SEM CPM, SEM BCS, and BW/CRM integration. He also has experience with tuning the overall performance of very large systems. He has worked on implementation projects in North America and Europe. Nurullah is an accomplished BW/SEM instructor. Nurullah is a senior SAP BI consultant working for Turquoise Consulting, which specializes in SAP Business Intelligence solutions. He played a major role in developing Turquoise' SEM and BW implementation methodologies.

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.