Skip to Content

  Applies to:

  SAP NetWeaver Business Warehouse (formerly BI). This will work on SAP BI 7.x versions.

Summary :

This document will help to understand the process of Archiving while dealing with SAND server as external storage for Archiving.

This archiving procedure may be treated as general while the external server may vary as per project to project.

Authors: Arpit Khandelwal, Asish Kumar Sahu.

Company: Accenture Services Pvt. Ltd.

  Author’s Bio:

s1.JPG

  Arpit Khandelwal is a SAP BI Consultant currently working with Accenture Services Private Limited. He has around 2 years of experience in BW/BI implementation and support projects. He has been particularly involved in Archiving Activities in SAP BW system.

Asish is  working as SAP BI Consultant with Accenture Services Private Limited. Skill set includes SAP Business Intelligence, ABAP and Business Objects .

  Methodology::

  Scope of an Archiving project needs to be defined while starting a Archiving Project.

For this, you need to identify the DSO’s and Infocube’s where most of the data is retained for many years.

Next part of the project scope is the Basic Housekeeping Activities for the System/Log Tables.

Also apart from the System/Log Tables we need to do housekeeping for the Data Targets also with the data that might

be obsolete for reporting or legal retention purpose.The House Keeping Activities part has already been covered in my

earlier document at http://scn.sap.com/docs/DOC-39735

Here in this article, we will specifically learn how to Archive data in BW system using DAP’s (Data Archiving Process).

For this, the assumption is that reader has already established a proper external server connection and DAP’s are already

created for the DSO’s & Cube’s.

What is DAP??

DAP (Data Archiving Process) is similar to a DTP (Data Transfer Process) in a BW system.

DAP is used for archiving which is similar to running a DTP to load data. A DAP will look as shown below.

/wp-content/uploads/2013/03/s2_199894.png

Steps to Archive data using DAP ::

1) Verify the configuration of a DAP

For this,we need to use Tcode RSDAP.

s3.JPG

  Mention the name of the Object type (DSO/Cube) and name of that DSO/Cube.

  s4.JPG

  Click on display to check the configuration.

Now click on the Server Check button marked in Red in below screen.

s5.JPG

The server connection should show status as GREEN then only we can proceed with the Archiving.

If there is some issue with the setting, then we need to check the same with our server maintaining team.

s6.JPG

2) To verify the data present in the source Cube/DSO.

When the DAP runs, it will sent the data marked in the time-period range to the SAND server.

Once this is done, it will delete the same data from the Cube/DSO.

To prove this, we are checking the data in Cube prior to running the DAP.

Checking data availability in cube for period 09.2008-11.2008

  s7.JPG

  Data in Cube for above selections::

s8.JPG

  It means data is available in the cube and can be archived.

3) Verify that Cube data is compressed (pre-requisite for Archiving an InfoProvider data)

All the requests in the Cube should be compressed.

s9.JPG

4) Verify the creation of Archiving (nearlining) request based on the Partitioning characteristic to nearline the data

  In our case, the Partitioning Characteristic will be Calender Month and we are going to perform Archiving for

  period 08.2008-11.2008.For this, go to the Info-Cube/DSO through RSA1 T-code and click on the Archiving Tab in Manage

  of the infoprovider.Kindly note that there will be only one specific DAP for a Cube/DSO.


  Once this DAP has been created, then the Archiving Tab in Manage of Infoprovider will be created automatically.

  Once you goto the Archiving Tab, click on symbol “Archiving Request”.

s10.JPG

  Provide the range of months you want to Nearline/Archive the data.

Make the continue process until target status as 70.Run the job now in Background.

s11.JPG

s12.JPG

  Check until the request turns to green.

  After this converts to GREEN status, check the data for same range in Cube as we did earlier.

s13.JPG


  What will happen to reports based on this Info-Cube??

As the data has been deleted from the cube and sent to SAND server, the report will not display data related

to Archived/Nearline period any more.To read the archived data as well in the report, we require a small change in the

Query Property which is explained as below.

Point 1) Open the report in RSRT T-code. Click on the Properties button.

s14.JPG

  Point 2) Put a check on the option “Read Near-Line Storage As well”.

s15.JPG

  How to bring back the Archived/Nearline data back to BW system from SAND Server??

  Goto Archiving Tab of the InfoCube/DSO whose data needs to be brought back to BW system.

Check the request with the Data Period Range of data which needs to restored back to BW.

Double click on lock symbol for that Time Period request.

s16.JPG

  After double-clicking on LOCK symbol, a dialogue box will appear as shown.

s17.JPG

  Run this reload of data back from SAND server to BW in background.

s18.JPG

  Another dialogue box will come. Click YES to continue ahead.

s19.JPG

  Well this will take some time, you can monitor the request status to turn green again.

s20.JPG

  Once this is over, the request data will be restored back from SAND to BW.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Ignacio Arango

    Hi Arpit: I have a question regarding DAPs. While a DAP is working, the corresponding Infoprovider is somehow blocked to a corresponding DTP? In other words: is it safe to run a DAP and a DTP at the same time? This question is important for me to program the process chains in order for them not to collide. Thanks!

    (0) 
    1. Arpit Khandelwal Post author

      Hi,

      Yes, the corresponding object will be locked while there is a run in either DTP or DAP so its better not to run them in same time to avoid lock.

      Best Regards,

      Arpit

      (0) 
      1. Damodaran Kuppurajan

        Arpit,

        I have read your documents – prerequisite steps for archiving. Interesting and useful document.

        I am new to Archiving activities. Is there any document you can point to for selecting the right tools and procedures/steps for Archiving in BW7.3 environment?

        Also, is DAP using SAND server applicable for both NLS and Offline archiving?

        Any thoughts and comments are appreciated.

        (0) 

Leave a Reply