Both archiving and Nearline allow a reduction of a database size ⇒ that results in improved speed of performance (online system). However, accessing archived data is more complex and slower than is the case with Nearline storage, and can also negatively affect the performance of the main database (In the case of data reload into that database).
NLS in the Context of ILM for SAP BW
Relevant data ⇒ BW Accelerator
Irrelevant data ⇒ Offline Archive
Potentially relevant ⇒ NLS storage (compressed data management)
ILM in SAP BW System
Data flow in BW ILM with SNP OutBoard™ NLS
NLS Writer for SNP OutBoard™
NLS Writer for SNP OutBoard™ is an enhancement of the standard SAP process for loading and activation in SAP BW. NLS Writer enables loading (for InfoCubes) and activation (for DataStore Object) of data within a locked period and the subsequent moving of data to the SNP OutBoard™ archive.
Normally, when data is loaded into SAP BW and part of this data is archived by SNP OutBoard™, the request will fail, because of the locked period. However, there are some scenarios there may be the need for old data to be loaded into the system on a frequent basis. To avoid failed load requests due to archived data in SNP OutBoard™, the NLS Writer was developed.
The NLS Writer extension solves this particular issue in the following way:
1. DataStore Object:
- Before data activation, NLS Writer recognizes whether records are from a locked area.
- In case these records are in a locked area, the NLS writer loads records with the corresponding key from NLS to an active table
- Locked data check is suppressed, and the request is activated in a standard way by SAP.
- After activation, locked records from the active table are moved back to the NLS archive.
2. InfoCube:
- During data load (Data Transfer Process or InfoPackage), NLS Writer recognizes if loaded records are from a locked area.
- In case the records are in a locked area, the NLS archive is updated with this data.
- Locked records are removed from the data load.
- Only non-locked data is loaded into InfoCube using a standard way.
NLS Writer with ADSO support
NLS Writer with ADSO support, in addition to DSO and InfoCubes, enables Writer for following objects:
- Advanced DSO - Data warehouse layer - delta calculation (ADSO like DSO)
- Advanced DSO - Data warehouse layer - data mart (ADSO like Cube).
ADSO like Cube does not support parallel processing of DTP.
Set up the 'Number of processes' to 1 in the upper menu Goto → Settings for Batch Manager.