Archiving Process, Phases 2 and 3: Archiving and Retrieving

  • by Ned Falk, Senior Education Consultant, SAP
  • February 1, 2009
Discover phases 2 and 3 in the archiving process: archiving and retrieving the archive data by restoring it to an InfoCube.
Key Concept
The difference between archiving and deleting lines is the ability for archiving to restore data previously removed from the SAP NetWeaver BI database. Using classical archiving, the data is restored back to an InfoProvider for reporting.

In 2004, a financial company archived all its data from August 1996 and earlier using the Archive Development Kit (ADK)-based archiving process, a component of the overall SAP NetWeaver BI support for archiving and information life cycle management.

This is phase 1 of the archiving process. In this phase, the company created the archive process object, which in turn created the archiving object for ADK-based archiving. In phase 2 you perform the actual archiving by removing the data from the database (InfoCube or DataStore object [DSO]) and send it to the ADK file structure.

Unfortunately, five years later an emergency occurs and Alex the auditor needs to review data from February 1996. Now you must perform phase 3 of the archiving process, in which you retrieve the data by bringing it back from the ADK file structure so you can review it and report on it.

I’ll describe phases 2 and 3, showing you how to archive the data and then recover it for a hypothetical emergency need. Figure 1 shows the pre-August 1996 data that the company archived in 2004 that I use in my example. It is from an SAP NetWeaver BI InfoCube named T_SDDEMO2, which I access using transaction LISTCUBE.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

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.