Create Data Archiving Process

For InfoProviders (InfoCubes and DSOs) a standard Data Archiving Process has to be created to archive the data first. 

As of SAP BW 7.30, Advanced DataStore Object archiving is supported. This feature does not apply to Mass archiving yet. Almost every ADSO type is supported. NLS reporting is available for the Cluster, File, MSSQL, Sybase IQ, MaxDB, DB2, and Oracle databases.

For PSAs and Change Logs the archiving is done only inside OutBoard. 

1. Data Archiving Process (DAP) can be created by using transaction RSDAP or from the Administrator Workbench (transaction RSA1) by selecting an InfoProvider
   1. Select your InfoProvider from the context menu
   2. Select "Create Data Archiving Process" (if none exists) or go to "Data Archiving Process", where you can Display, Change and Delete Archive processes.

2. When archiving a group of objects, above the standard SAP functionality, OutBoard provides automated DAP creation as mass processing. (See section on Mass archiving for more details)

   ΤA: RSDAP / RSA1

   _{DAP creation in RSA1}

3. When creating/ changing the DAP there are five tabs

• General Settings
• Selection Profile
• Semantic Groups
• ADK (automatically switched off if OutBoard archiving is used)
• Nearline Storage

What needs to be set up for OutBoard is explained in more detail below.

_{Creating the data archiving process}

General Settings

Identifies the type of archive storage used on a system, i.e. "ADK-Based Archiving", NLS, or both. OutBoard works without ADK-Based Archiving.
So to enable storage by OutBoard:

• Uncheck "ADK-Based Archiving"

Enter "OUTBOARD" as "Nearline Connection".

_{Connection status of OutBoard}

Selection Profile

Determines, which InfoObjects archiving requests are created. In figure 9, in the general settings tab under 'selection profile' Time Slice Archiving was selected therefore time characteristics can be used as primary partitioning characteristic, but when time characteristic is not in key also any non-time key field can be used as a primary partitioning characteristic.
Typical Time Slice Characteristics are:

• Calendar day
• Calendar year/ month
• Calendar year
• Fiscal year
• Fiscal year/period
• Request Date Created (for WODS)

By choosing 'Allow Arch. of non-compressed data', the user is also allowed to archive the data from F-table = non-compressed data. If you decide to allow this, the performance of archiving is lower, because needed SELECTS are more complicated. This option is available as of SAP BW 7.30. 
To further partition data use the InfoObjects under 'Additional Partitioning Characteristics', by selecting from the table of InfoObjects on the right and moving them to the left table (using arrows).

_{Selecting Additional partitioning characteristics, tab Selection Profile}

If a non-key characteristic is used for archiving warning messages and a log with further information is displayed, it is highly recommended to select the time characteristic that is a part of the DSO key. The InfoProvider key fields that are available for selection are highlighted as shown in the figure below.

_{Characteristic selection}

When there is no time characteristic in the key of the DSO, then the “characteristic for time slice” refers to a time characteristic in the data field of the DSO. The primary partitioning characteristic refers to the selection defined in the Data Archiving Process. The way archiving works is that the system will select all primary partitioning characteristics that are older than the date of the “characteristic for time slice.

Semantic Group

Due to the size of the requests that are going to be archived, these must be split into smaller parts, called "data objects".
Data objects can be defined in the Semantic Group tab of a DAP. If undefined, by default a data object is created for every 50 000 records. 
In the "Semantic Group" tab you specify the structure of your archived data in a sorted way and distribute into data objects. The system reads from the database after sorting according to grouping characteristics.

_{Archived data structure}

For example, if 0CALYEAR and ZMANAGER are chosen, data objects could look like this:

_{Creating a Data Archiving Process, the tab Semantic Group}

Nearline Storage

This tab gives an overview of the Nearline connection and size of the data package (data packet up to SAP BW 7.02). Data objects are grouped into data packages. When a request is loaded via DTPs, it can be parallelized on the data package level.Nearline Storage

_{Creating the Data Archiving Process, tab Nearline Storage}

We recommend keeping the size of the Data Package low:

• InfoCubes: 50MB
• DSO: 100MB
• For objects over 500 million records, should be higher (200 - 500 MB)

To determine how a new Data Package is created can be done in two ways :
1. By defining the "Maximum Size in MB":

• For InfoCubes 50MB
• For DSO's  100MB

2. By defining the "Maximum Number of Data Objects":

• InfoCubes: 50
• DSO: 100

→ We don't recommend using this option (number 2), because the size of a DataObject can be unpredictable

Activate DAP

Once the OutBoard settings have been completed,  activate the new data archiving process.

When using OutBoard with Storage Management you will be asked to select the OutBoard archiving profile (for more information please see the section: OutBoard Cockpit -> Settings). 

_{Aging profile selection}

Once activated a Log Display will appear:

_{Data Archive Process activation Log}

The following solution reloads while activating a request, all the duplicate records from the archive in the active table, and overwrites them with the new data. 

Set an infoprovider to support reload of duplicates

• Open the /DVD/NLS_SET_RELOAD_DUPLICATES report.
• Insert names of your InfoProviders.
• Check the 'Support reload duplicates' to true to activate the functionality, ('false' to deactivate it).
• Execute.

Editing the DAP

"Edit Data Archiving Process" via transaction:
RSA1
RSDAP :
a/ In the context menu of the chosen InfoProvider
b/ Choose the object type you desire by clicking on the drop-down menu in "Object Type". The Object Type can be either an InfoCube or a DataStore Object
c/ Fill out the "Obj. Name" with the name of the InfoCube or DataStore Object you wish to work with
d/ Process to Display / Edit.  Here you can view the status of whether the DAP is active or not.

_{Transaction RSDAP - Display/Edit/Delete existing DAP´s}

_{Displaying the Data Archive Process}

Delete DAP

To delete a DAP, open the transaction RSDAP and press "Delete" for the chosen InfoProvider (DSO) or in RSA1 select the InfoProvider from the context menu and use Delete in the Data Archiving Process.