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

Process chain to load only new requests from PSA

I have a data model where the data flows from PSA to InfoCube through a DTP. I have set delta as the update type in DTP level and update type was by default, full for PSA. Now I am having a process chain to execute the whole loading process.

The problem is that data is correctly being loaded into PSA but it is being duplicated in the InfoCube because the chain runs all previous requests from the PSA. This is causing duplication of loads. How do I prevent this?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 11:09 AM

    Hi

    This is a small bug in bi7.I don't know whether it is rectified with new SPs..as i worked on bi 7 one year back.then SP level was 10...

    we need to delete psa data first then load the data, and then take the DTP in the process chain,else all the available requests will be taken by DTP..

    Thanks,

    Teja

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 10, 2008 at 11:49 AM

    Most probably your PSA must have 1 more request for the same load.

    Right click datasource->manage and in the Request for PSA screen change the "Request newer than" field with a old date (make it like 2006). So now you would be able to see 2 requests. One you loaded recently and one more with a old date. So delete the request with the old date and re-load the cube again.

    OR

    If not two requests, put a ABAP statement like the following:

    "Delete adjacent"..... in the transformation start routine.

    It should be ok.

    Hope it helps..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 12:12 PM

    Hi,

    Add Process : Delete PSA at the end of your Process Chain.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 01:54 PM

    Add a process type " Deletion of Requests from PSA" in ur process chain. put this process before ur infopackage executes.

    start process -> deletion of PSA -> execute infopackage -> execute DTP and so on...........

    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.