Selective Deletion from Advanced DSO (Advanced Data Store Object)
A short How-To guide on selective deletion from an ADSO
The Advanced DataStore Object (ADSO) was introduced in SAP BW 7.4 SP8. Its design was meant to simplify the SAP BW landscape. Currently, SAP BW offers a large number of objects that can be used for data modeling. These objects have their pros and cons and some are preferred over others depending on the data model they are used for. The Advanced DSO consolidates the functionality of a DataStore Object, a PSA, an InfoCube and a Hybridprovider into a single object and completely replaces these objects in data models built in BW 7.4 SP8 and onwards. In older versions of BW, selective deletion for a DSO was conveniently available as a button through the “Manage” screen which is accessible through the context menu of the object. Unfortunately, this is no longer the case with ADSOs. The option is now hidden in the “Environment” drop-down menu of the Manage screen which is not as intuitive as it used to be.
Selective deletion from ADSO can be also done with a standard ABAP program. In transaction SE38, you need to execute program RSDRD_DELETE_FACTS, select the Advanced DSO, enter the selection criteria and execute.
Before executing the program, there are 3 program properties available. If You choose “Generate deletion program”, you can set a name and use the program later. The deletion program can be used in process chains too.
Another transaction DELETE_FACTS, uses the same ABAP program for selective deletion form an Advanced DSO.
In the ADSO there is no request-based deletion available, so selective deletion remains the only option for removing data.
Experienced Data Processing Specialist with a demonstrated history of working in the market research industry. Skilled in Research, Market Research, Microsoft Excel, Management, and Analytical Skills. Strong administrative professional with a Computer Systems Technician focused on Computer Science from TUES - Technological School "Electronic Systems".
DAHLBEER ensures your business objectives are achieved. Our vast experience and technical expertise in SAP planning tools enables efficient implementation in short cycles. Dynamic and Reliable – It’s how we are known to our clients.
Phone: +49 (0) 1515 629 66 08
Impressum & Datenschutz
Dahlbeer Unternehmensberatung GmbH
Landshuter Allee 8-10
Tel: +49 (0) 89 / 998 20 84 80
Fax: +49 (0) 89 / 998 20 84 89
Geschäftsführer: Christoph Dahl, Philipp Beer
Sitz der Gesellschaft: München
Registergericht: AG München HRB 201525
Umsatzsteueridentifikationsnummer (UID): DE285620916
Inhaltlich verantwortlich gemäß § 55 Abs. 2 RStV: Christoph Dahl, Philipp Beer