Skip to Content
author's profile photo Former Member
Former Member

Delete overlap request in DSO

Hi All,

I have a reqquirement to delete the Request as Delete overlap request in DSO.

I know that there is a Process type availabe.but this only for Infocube.

can you pls help me how to get the similar kind in DSO.

Thanks,

Anilkumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2012 at 01:00 PM

    Hi,

    if you don't want to create a program to delete overlapping data in your dso you can create a transformation from your dso in the same dso (ringload). You have to use the same selection in this dtp as in your infopackage/ dtp in this dso. You have to use this coding 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. After doing the ringload you have to activate data in dso. After that you can load the deleted data into InfoCube or DSO per delta-dtp. You don't have to delete overlapping requests in InfoCube because of the ringload.

    Regards,

    Yvonne

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Anil,

      here is an example for a datamodel:

      infopackage (full) datasource -> PSA (for example July 2012)

      delta dtp PSA -> DSO

      delta dtp DSO -> InfoCube

      When you load July 2012 again, you have to delete the old data in the DSO and in the InfoCube. For this you can use the ringload. Before you load July 2012 again in PSA you do the ringload for your DSO with a DTP full mode and selection July 2012. After that you activate your DSO. Now you can load July 2012 again in your DSO. Activate Data. After that you load the new requests (deleted data and the new data) from DSO per delta into your InfoCube. The old data is deleted in InfoCube and it is updated with your new month data.

      Regards,

      Yvonne

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2012 at 08:39 AM

    Hi,

    The DSO does not hold the request number in the active data table, therefore it is not possible to delete overlaping requests.

    However the DSO works with overwrite, in oppose to an infocube, so you could overwrite data that has the same DSO key - leaving only the most current as available for reporting.

    Regards ,

    Alex

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.