NLS Data

The purpose of this document is to explain to the end-user the process of installing, using, and updating SNP OutBoard™ – a data lifecycle management application for Near Line Storage (NLS) of SAP BW data.
This document is aimed primarily at SAP system administrators and BW consultants who should primarily work with SNP OutBoard™.

What is NLS?

Nearline storage (a contraction of near-online) is used to describe an intermediate type of data storage that represents a compromise between:
• online storage → supporting frequent, very rapid access to data
• offline storage / archiving → used for backups or long-term storage, with infrequent access to data

In this section:

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.

Browser not supported