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.
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.
Would you like to see this full item?