DSO delete overlapping requests

[Former Member]

Hi Gurus,

I have 4 full infopackages in my DSO that will load to PSA and a DTP that will load the extractd data from th 4 infopackages. This is a monthly basis report and the reason that I am planning to have a delete overlapping is we will load the extractor daily on a full load due to backposting from ECC side, so based on the month inserted on the filter in infopackages and dtp, everyday it will generate a new extraction so i need to delete the yesterdays load to update the values.

Is there a way I could have delete overlapping in the process chain in SAP BW for DSO?

Your inputs are very much appreciated.

[RamanKorrapati · Accepted solution]

Hi,

There is no option to delete overlapping requests from DSO. its only for info cube only.

You can write one abap program and  try to delete the loaded requests from DSO.

Requests you can read from below tables based on your target.

RSICCONT

RSODSACTREQ

RSBKREQUEST

You can add abap program to your process chain.

Thanks

[Former Member]

Hi Menace,

Overlapping request deletion is not possible in DSO since the active table doesnt contain request number.

You can use the DSO in overwrite mode for the fields with same Key , so every load will overwrite the data previously stored.

You can also create a self loop on the DSO transformation and delete the data using start routine before doing fresh full load.

Thanks

Nayab

[former_member185177]

Hi Ethan,

As "Ram" suggested you the table names to write an ABAP program.  Yes we did it with the below mentioned tables.

RSBKDTP, RSBKREQUEST, /BI0/SREQUID, RSSELDTP and with the code suggested by "Seshu".

Can you go through Link/program as the code is already there.

http://scn.sap.com/docs/DOC-32954

Hope it helps you.

Regards,

Krishna Chaitanya.

[Former Member]

Hi Ethan,

If you are using a Standard DSO it will automatically "Overwrite" based on the Keys defined. So records coming in with same keys like Record Number will be overwritten and you have only the latest records in the DSO. Therefore, "deletion of overlapping request" is not required for a DSO.

Use transaction DELETE_FACTS to create the selective deletion program for the DSO. Then create a program that calls this program as a sub-program and use it in ABAP Code section in process chains.

You can also use this program in Start Routine :

DATA: wa_data_package LIKE LINE OF SOURCE_PACKAGE.

    wa_data_package-recordmode = 'D'.  "Set 'Delete' mode

    MODIFY SOURCE_PACKAGE FROM wa_data_package

      TRANSPORTING recordmode

      WHERE recordmode = space.              "for all records

The records in the dso are set to delete mode. Perform a self-load to this DSO and activate.

Thanks,

Prabhav

[timkorba]

I agree with Nayab as I don't believe you need to delete the overlapping data.  If you have overwrite for the DSO key figures, then everything that is the same for the key will be overwritten.  When you activate you will have 1 record.  In addition, this will track the correct updates that need to be sent to the InfoCube, if one exists, using the delivered delta capability and best reason to not delete your DSO if you don't need to and do complete overwrite as the change log will track only the changes that were made.

[former_member199945]

Try with Below Options :

1. using DELETE_FACTS For  more information refer oss note 415315

2.Search in SCN for below Document provides details steps for deleting overlap requests.

ABAP Program to delete the requests from the WO DSO's  :  Posted By JAI GUPTA