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

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • March 1, 2006
Archiving BW data reduces its volume, resulting in faster loads and queries. This first article of a three-part series explains the entire process to archive ODS or InfoCube data step by step.
Key Concept

Archiving is available with BW Release 3.0B and above. You can archive from InfoCubes and ODS tables, but currently you cannot archive with Persistent Staging Area (PSA) tables or master data. When archiving from ODS tables, the system only archives the active data. Therefore, you should ensure that you’ve activated all relevant data packages prior to starting the archiving run.

Any data warehousing system amasses and analyzes data at an increasing rate. As time progresses, companies face the dilemma of storing more and more historical data. This data tends to lose its daily relevance and users access it less frequently. At this point, you can consider archiving.

Archiving allows you to offload data to another storage medium while giving you the ability to reload this data into the BW system for reporting. Archiving data typically allows the system to achieve faster data loads and quicker query results by decreasing the volume of data in your BW system.

I’ll describe the complete archiving process from beginning to end in a series of three articles. Part 1 is a general overview of archiving in BW. In part 2, I’ll show how to reload the data that you have archived back into your BW system. In part 3, I’ll discuss the process and pitfalls of loading R/3 archived data directly into BW.

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.