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

Please Help Delete Overlapping Request Process Type

Hi,

I have to include the Process Type Delete Overlapping Request from Infocube in my existing chain.

But the cube is already having data in it and i am not able to include the exisitng DTP in this process type.

The DTP is Delta Load selected and i think unless i dont change to Full Load i cannot find that DTP in process type.

I am not able to change to full load as data exists.

Can anyone please help what is possible solution for this?

I tried to move data to copy but its not loaded correctly as many other DTP's with semantic key selections have provided data to this cube.

Also can you please tell me if i use Info Package in this process type will it do same function as if i include DTP?

Regards

Syed

Edited by: Syed786 on Aug 24, 2011 9:02 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 07:15 AM

    Hi Syed,

    I think you are working on SAP BI 7.0.If you want to delete overlapping request from CUBE, then you have to use DTP, if it is from PSA then you can use IP.

    Check the below threads

    Regarding Overlapping Request - Where to add

    Have to tried to change extraction mode from delta to full in change mode of DTP.

    If you are not able to change, then i think you need to delete the data from CUBE and load the data again as full load.

    now use delete overlapping request process type in process chain.

    Check the below article

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0431c48-5ba4-2c10-eab6-fc91a5fc2719?QuickLink=index&overridelayout=true

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 07:50 AM

    Hi,

    Delete overlapping request is used for full loads , and this is mostly done when you are loading data to infocube, so that data duplication will not happen. In your case as you mentioned that DTP type is delta, then why do you want to delete overlapping request, as each of your delta will be different and it should be persisted in cube otherwise there will be data loss.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Durgesh,

      So you mean that using this process type for delta DTP's is of no use?

      My client has requested to use this in chain.

      I am just wondering now how will this process type help then?

      If this is delta wont there be two request loaded with same Id?

      Regards

      Syed

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.