The global and independent platform for the SAP community.

Stragglers to the archive

Until now, the effort required to update archived BW data was very high, because so-called stragglers could not be posted directly to nearline storage. This kept many BW users from archiving data.
E-3 Magazine
February 1, 2017
[shutterstock:562359937, Maksim Kabakou]
avatar
This text has been automatically translated from German to English.

Archiving of DataStore objects was previously performed on the basis of time slices. An archived time slice is locked and write-protected by the BW system.

If, after archiving, a document belonging to this time slice, a so-called straggler, is to be transferred to the Business Warehouse, it is rejected because of the time slice lock.

The document data is therefore not available for reporting. The lock can only be removed by reloading the archived data. The data must then be re-archived together with the straggler.

Therefore, much data remains in the database longer than necessary and the benefits of archiving to nearline storage cannot be realized.

The way out of this dilemma is offered by the straggler management in CBW NLS. It enables the archiving of stragglers and their updating for DataStore objects.

Straggler management is activated by a few administrative steps: First, the update with writing to the error stack is activated for the data transfer process of the affected DataStore object. Then, additional objects are generated for each affected DataStore object using a PBS-specific administration transaction.

After activation, all stragglers can be easily transferred to Nearline Storage and posted.

Once the stragglers have been updated with the corresponding PBS transaction, they are included in reporting. In addition, they can be included in the update in the subsequent objects, such as InfoCubes, using the generated objects.

Thanks to this new functionality in PBS CBW NLS, archiving of DataStore objects in BW no longer needs to be abandoned. On the contrary, it enables more aggressive DSO archiving.

Due to the high data compression and the very short response times of the SAP IQ and IBM DB2 BLU nearline databases used, a significantly improved SAP BW system performance is achieved at lower operating costs.

Advantages

CBW NLS achieves high data compression through the column-based NLS database. Very fast NLS data access shortens the query runtime.

An additional performance increase is achieved for queries with navigation attributes and hierarchies.

A smaller primary database simplifies the transition to BW on Hana. The Straggler Management solution from PBS supports the Unicode conversion of the BW system.

avatar
E-3 Magazine

Information and educational outreach by and for the SAP community.


Write a comment

Working on the SAP basis is crucial for successful S/4 conversion. 

This gives the Competence Center strategic importance for existing SAP customers. Regardless of the S/4 Hana operating model, topics such as Automation, Monitoring, Security, Application Lifecycle Management and Data Management the basis for S/4 operations.

For the second time, E3 magazine is organizing a summit for the SAP community in Salzburg to provide comprehensive information on all aspects of S/4 Hana groundwork.

Venue

More information will follow shortly.

Event date

Wednesday, May 21, and
Thursday, May 22, 2025

Early Bird Ticket

Available until Friday, January 24, 2025
EUR 390 excl. VAT

Regular ticket

EUR 590 excl. VAT

Venue

Hotel Hilton Heidelberg
Kurfürstenanlage 1
D-69115 Heidelberg

Event date

Wednesday, March 5, and
Thursday, March 6, 2025

Tickets

Regular ticket
EUR 590 excl. VAT
Early Bird Ticket

Available until December 20, 2024

EUR 390 excl. VAT
The event is organized by the E3 magazine of the publishing house B4Bmedia.net AG. The presentations will be accompanied by an exhibition of selected SAP partners. The ticket price includes attendance at all presentations of the Steampunk and BTP Summit 2025, a visit to the exhibition area, participation in the evening event and catering during the official program. The lecture program and the list of exhibitors and sponsors (SAP partners) will be published on this website in due course.