Improve Your System Performance by Archiving Data in BW: Part 3

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • May 1, 2006
Follow these steps if you need to load archived SAP R/3 or mySAP ERP Central Component data back into BW.
Key Concept
You typically use the BW setup programs in the R/3 system to fill the transactional data setup tables for a BW new implementation. You can also use the programs to fill setup tables with data that the R/3 process team previously archived in the R/3 system. This allows you to directly load the archived data into BW from these setup tables.

To cope with the increasing size of your transactional system, you can periodically archive data in your SAP R/3 or mySAP ERP system. This process selects a subset of data, writes this data to a file, and removes it from the system. Sometimes you need to load this archived data into BW.

For example, a company has been live on R/3 for five years without implementing BW. Because of the large sales volume, it archived the first two years of order data. It then decided to implement BW. The BW users demanded five years of detailed order data in BW. This posed a problem because these orders were already archived in the R/3 source system.

The company could take the archived R/3 data and reload it back into the transactional system and then load the data into BW. However, this can be a time-consuming task that would take considerable R/3 system resources to accomplish. Plus, once the load over to BW is complete, you usually have to re-archive the data.

I’m going to show you a better way. BW Release 3.0B and later allows you to read the actual archive files in certain cases via use of the setup programs in R/3. This removes the need to reload these archived records back into R/3.

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


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.