How do you do selective deletion in a process chain?

How do you do selective deletion in a process chain?

Steps:

1. Add a selection variable to the TVARVC table.
2. Create a program and variant for the selective deletion of the cube with transaction DELETE_FACTS.
3. Create an ABAP Program to insert the dynamic variables in the TVARVC table.
4. Add the ABAP Program from step 3 and step 2 to the process chain.

What is selective deletion?

Selective deletion from DSO refers to deleting specific values from a DSO leaving the other values unaffected. These values are deleted based on specific variables like Calendar Date, Account No. etc. Selective deletion allows you to delete by characteristic as well as by request.

How do you do selective deletion in DSO?

for selective deletion, go to the DSO and select Manage after right-clicking the DSO. Go to the contents Tab. Now to start the deletion process press the Start button.

How do you create a selective deletion program?

Choose ABAP program process type under general services.

1. Click on create give the name and it will prompt you for ABAP program give the program name& save it.
2. Connect this ABAP program process to Start process.

How do I delete my adso data?

In RSA1 based modeling, regardless of the type of infoprovider, we could right click on the object and delete the data from it. In BWMT, right clicking an ADSO in BW repository tree doesn’t give any such option at all. Even in the manage screen, there is no option to delete the entire data from the ADSO.

Can we delete activated request from adso?

After getting output select that request and display so you will see the screen below like this, Then through debug mode change the Y status to RR(This means making request red) and save the record. Check the monitor screen of ADSO request will be marked as red. Then we can delete the request manually.

How do I remove adso activation request?

How do I delete adso in SAP BW4HANA?

Choose Environment → Delete Active Data in the main menu, to delete data from the active table, and if required, rebuild the data later. This also applies to the data of the inbound table and the change log.

What is adso SAP BW?

In BW4HANA system, ADSO (Advanced Data Store Object) is the primary persistent object used in data modelling. This blog explains the different tables created when using an ADSO and how a full/delta/initial load updates/fetches data from these different tables.

How do I get rid of adso Yellow request?

Hi, There is a yellow DTP request which actualy has already been stopped, in manage of a master data info object attiributes. We did a server restart as well.

How do I remove adso request?

What is LSA and LSA ++ in SAP BW?

LSA is built with several layers, and data is physically copied from one layer to another. When we implement BW on HANA, we can create a different flavour of Layered Scalable Architecture, much simpler, smaller, faster and that relies more on virtual objects and less on copy of data between layers – It is called LSA++.

How to automate selective deletion in SAP?

To automate this selective deletion we need to use some variant in process chain to delete data selectively from data target. As there is no SAP given process type is available this has to be done through a different procedure. Suppose we have a infocube where we need to recalculate some values everyday considering last three weeks.

How to use selective deletion in process chains?

In this step we will use the document from Surendra Kumar Reddy Koduru – Using Selective Deletion in Process Chains. Go to the DELETE_FACTS transaction. Fill in your data target from where selective deletion needs to be done (cube). Make sure to select “Generate selection program” and click on execute. A Name of report will be shown.

How do I delete a variant from a process chain?

The process chains variant’s attributes are read from the generic variant storage tables – this includes the provider to be deleted from, and the selections. Finally the function module RSDRD_SEL_DELETION is called for the deletion itself. The messages of the deletion are written to the process chain’s log.

How to select selective deletion of the infocube using ABAP program?

Use transaction DELETE_FACTS and generate ABAP program and variant for the selective deletion of the infocube Create an ABAP Program to populate the dynamic variable in the TVARVC table. Add the ABAP Program from step 3 and step 2 to the process chain. The process chain will have following sequence of variants.