(2211) Writer
- SNP
Analytics
Writer is an enhancement of the standard SAP process for activation in SAP BW. Writer enables loading and activation of data that overlap with offloaded data.
Normally, when data is loaded into SAP BW and part of this data is offloaded by OutBoard, the duplicate records are loaded into the active table.
The Writer solves this particular issue in the following way:
In this section:
Before data activation, Writer recognizes whether there are any locked records in the archive.
In case there are some locked records, the Writer loads records with the corresponding key from the archive to an active table.
The request is activated in a standard way by SAP.
Functional limitations
Writer has limitations displayed in the table below:
Functionality | Limitations |
|---|---|
Supported DataProvider types |
|
Writer without index
Index table is used by Writer to quickly identify locked records in the archive. However, in some cases, the index table could take a lot of space or is not frequently used (e.g. only delta loads are executed).
If the index table should not be used, the identification of locked records is done this way:
Temporary table is created in the target storage
Loaded data are filtered based on the condition of all offloaded data and inserted into the temporary table
Join is executed between the temporary table and the archive to identify locked records
Performance of this process highly depends on the number of loaded records and the type of storage. For transparent binary storages, it's recommended to always use the indexes.
To use Writer without index:
disable setting USE_INDEX for the DataProvider with no offloaded data,
or execute reports /DVD/OFF_INDEX_DELETE and /DVD/OFF_INDEX_CREATE (“With data” flag unchecked) for DataProvider with offloaded data.