DATA ARCHIVING PROCESS IN SAP BW
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 2 : In the ‘General Settings’ tab, check the box ‘ADK-Based Archiving’. System will assign the archiving object name for the infoprovider.
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 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.
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 6 : Give a variant name and click on MAINTAIN.
STEP 7 : In the pop-up window, select ‘For All Selection Screens’.
STEP 8 : In the tab ‘Primary Time Restrictions’, maintain the details with respect to your requirement :
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 10 : Come back and save.
STEP 11 : Enter the description i.e text for Variant Name
Save and come back
STEP 12 : Click on Start date and schedule it.
STEP 13 : Click on ‘Spool Params’.
STEP 14 : Enter the ‘Output Device’ and press Enter button
STEP 15 : Click on ‘Execute’.
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
STEP 17 : Select “Archive Selection”
STEP 18 : Select the archived file and press Enter.
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.
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.
STEP 3: In the last tab “Nearline” mention the size of the packet.
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.
STEP 5 : Once the activation is successful, come back to the infoprovider tree and click on Manage.
STEP 6 : We get a new tab “Archiving” and click on Archiving Requests.
STEP 7 : Fill in the details like based on what selections and conditions you would like the archiving to be done.
STEP 8 : After specifying the selections, click on Selection button in the “Primary Time Restriction” tab. Now select “Immediate ” schedule.
Once the simulation is successful, we can execute the archive run in dailog or Background mode
Select the target status as 70 under the Process flow control for deletion phase completion .
STEP 10 : Click on Yes.
STEP 11 : Once the archiving has completed, the request would appear in the Archiving tab like the below.
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.