Skip to Content

This document explains  the steps on how to create a DAP in sap bw, more information on what is archiving is covered in my archiving blog

How to create data archiving process based on ADK method

Step 1 : Go to transaction RSA1 and right click on the info provider you want to archive and select “Create Data Archiving Process”

step 1.png

Step 2 : In the ‘General Settings’ tab, check the box ‘ADK-Based Archiving’. System will assign the archiving object name for the infoprovider.

STEP 2.png

STEP 3 : In the ‘Selection Profile’ tab, select the ‘Characteristic for Time Slices’ as a Time Characteristic. And here we also select the info objects based on which we want the archiving to be done, and move them from right to left. We repeat the same process in next tab “Semantic Group’” as well.

STEP 3.png

STEP 4 : In the last tab ‘ADK’, enter the newly created logical file name, maintain the ‘Archiving File Size’, select Delete Job as ‘Not Scheduled’. This will not allow system to delete the data automatically from data target.

STEP 4.png

NOTE : Logical files can be created using the transaction “FILE”.

By doing these steps, we have successfully created and maintained an archiving object for DSO/Infocube

STEP 5 :Now that we have set up the ADK DAP process and defined the logical mpath,  Next step is to archive the data.

To archive the data go to t code : SARA and give the Archiving Object name, and click on ‘Write’(which is our first step in the ADK data archiving process Creation of archive files)

STEP 5.png

STEP 6Give a variant name and click on MAINTAIN.

STEP 6.png

STEP 7 : In the pop-up window, select ‘For All Selection Screens’.

STEP 7.png

STEP 8 : In the tab ‘Primary Time Restrictions’, maintain the details with respect to your requirement :

STEP 8.png

STEP 9 : In the tab ‘Further Restrictions’, give the details like on what basis  we want to archive the data i.e on  certain selection if any. And keep the processing option as ‘Production Mode’

STEP 9.png

STEP 10 : Come back   and save.

STEP 10.png

STEP 11 : Enter the description i.e text for Variant Name

STEP 11.png

Save and come back

STEP 12 : Click on Start date  and schedule it.

STEP 12.png

STEP 13 : Click on ‘Spool Params’.

STEP 13.png

STEP 14 : Enter the ‘Output Device’ and press Enter button

STEP 14.png

STEP 15 : Click on ‘Execute’.

STEP 15.png

We can check the status of the job by clicking on JOB button

This completes our first STEP in ADK and we have hereby successfully “written” the data from our infoprovider to the archiving file.

STEP 16 : Now that we have copied that data into our archiving file, we can now “Delete’ the data from our infoprovider.

T code : SARA and select the “Delete” option

16BB.jpg

STEP 17Select “Archive Selection”

17B.jpg

STEP 18 : Select the archived file and press Enter.

18B.jpg

STEP 19 : Click on ‘Start Date’ and click on ‘Immediate’ and SAVE.

STEP 20 : Click on ‘Spool Parameters’, enter the Output Device name and press Enter. Click on Execute button and the data gets deleted. You can the job overview and be confirmed.

Hence we have completed our first type i.e ADK based Data Archiving Process.

2) NLS (Nearline storage)

How to create data archiving process based on NLS  method

STEP 1: Right click on the infoprovider and select “create data archiving process”

Here uncheck the type “ADK” and specify the name of the NLS connection.

/wp-content/uploads/2012/08/2_1_125550.jpg

STEP 2 : In the ‘Selection Profile’ tab, select the ‘Characteristic for Time Slices’ as a Time Characteristic. And here we also select the info objects based on which we want the archiving to be done, and move them from right to left. We repeat the same process in next tab “Semantic Group’” as well.

/wp-content/uploads/2012/08/2_2_125551.jpg

STEP 3: In the last tab “Nearline”  mention the size of the packet.

/wp-content/uploads/2012/08/2_3_125552.jpg

STEP 4 : Activate the Data Archiving Process .

We get a log display like the below. So we have now setup the nearline connection for this particular infoprovider.

/wp-content/uploads/2012/08/2_4_125557.jpg

STEP 5 : Once the activation is successful, come back to the infoprovider tree and click on Manage.

/wp-content/uploads/2012/08/2_5_125558.jpg

STEP 6 : We get a new tab “Archiving” and click on Archiving Requests.

/wp-content/uploads/2012/08/2_6_125559.jpg

STEP 7 : Fill in the details like based on what selections and conditions you would like the archiving to be done.

/wp-content/uploads/2012/08/2_7_125560.jpg

STEP 8 : After specifying the selections, click on Selection button in the “Primary Time Restriction” tab. Now select “Immediate ” schedule.

/wp-content/uploads/2012/08/2_8_125561.jpg

STEP 9 : You can use this option /wp-content/uploads/2012/08/2_9_125562.jpgfor simulation .

Once the simulation is successful, we can execute the archive run in dailog or Background mode

/wp-content/uploads/2012/08/2_9_2_125563.jpg 

Select the target status as 70 under the Process flow control for deletion phase completion .

STEP 10 : Click on Yes.

/wp-content/uploads/2012/08/2_10_125564.jpg

STEP 11 : Once the archiving has completed, the request would appear in the Archiving tab like the below.

/wp-content/uploads/2012/08/2_11_125566.jpg

Hence we have successfully archived the data with respect to our selections.

We can cross check the cube content after archiving the data, where in you can see some changes in the content of the cube before and after archiving.


To report this post you need to login first.

8 Comments

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

  1. Manu Gupta

    This is really great document.

    It gives step by step usage.

    I am looking for an answer on how the data retrieval is there from a NearLine Storage system.

    Do you have any answer on this ?    

    Cheers!!

    (0) 
  2. Ricardo Sobral

    Hi Manu and Vibha,

    It is implicit here, but to activate the Nearline piece you need to have a solution implemented from a nearline partner.

    I am the product manager for Informatica ILM Nearline, one certified solution in the market.

    The specific question about data retrieval: at interface level, the nearline interface has methods that partners need to implement for data retrieval. Since the backend is different for every  partner, the retrieval process also differs.

    At query level, you have the option to tell SAP to retrieve the data from the nearline system of not. It is the exteded properties of the query in BEx or query properties, if you are using transaction RSRT.

    There are other places were you can tell SAP to retrieve data from nearline as well: at Open Hub level, at loading of Infoproviders where the downstream obhecjts has been nearlined, etc.

    Remember, these options only show up if the DAP has been created.

    If you have more questions, pelase ask me.

    Regards,

    Ricardo Sobral

    (0) 
  3. krishna **

    HI,

       Good document.

        i am doing the archiving for zcrm_prh object,and i configured like you for adk based archivng, in selection options i selected the calmonth (characteristics for timeslice),but my requirement is to do the archiving based on the posting date .

        How to get the posting date into selection-options for scheduling archiving jobs.

    Thanks,

    Krishna.

    (0) 
  4. Constantine Chebotarev

    Daily we archive objects

    – BC_DBLOGS

    – BC_SBAL

    – BWREQARCH

    – IDOC

    which are 90 days old

    into our content-server.

    Everything is working very well.

    Is it possible to delete old *archived* objects which are 5 years old?

    (to release freespace in the content-server (MaxDB))

    Or in which SCN-topic can I ask such question?

    (0) 
  5. Hercar Carvajal

    Hi!

    Could you please be kind explain to me the reason why into menu context does not appear the “Create Data Archiving process” option over an infocube??

    Thaks in advance

    Hercar

    (0) 

Leave a Reply