Monday, June 27, 2011

Clean old requests from Write-Optimized DSO

In the LSA setup the W/O DSO is often used to replace the function of the PSA table. By keeping all history in the W/O DSO you might encounter serious performance or data volume issues.

With program RSSM_DELETE_WO_DSO_REQUESTS it is possible to delete old requests in the Write-Optimized DSO, exactly like we are used to do with PSA requests via a Process Chain.
This program is available as of SAP NetWeaver BW 7.01 SP07. See note 1437407 for details.

You can automate the deletion of old WO requests by using the ABAP program step in the Process Chain.