Skip to Content
avatar image
Former Member

How to load selective request from PSA to DSO in 3.5?

Hi Gurus!

I am in BW 3.5 and loading daily DELTA loads from PSA to DSO and then to the Cube1 and Cube2.

Let's say we have 3 requests: #1 is the earliest and #3 is the latest.

PSA has request #1, and request #3 (it has no data and I am not sure that this is correct). Request #2 deleted.

DSO has only request #3 and it is not activated.

Cube1 and cube2 are not updated at all.

Should I first load request #1to DSO? and then update the Cubes? If yes, then how can I do this if i already have request #3 in PSA?

Next questions:

1. What should I do with request#2 ( not in PSA)?

2. If I delete request #3 from PSA (it has no data), will the next delta load (it will be #4) pick up #3 too?

Please advise

Thank you in advance!

Olga

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 11, 2012 at 06:37 AM

    Hi ,

    I would suggest that you can keep the request which has been successfully updated in all the data targets.Delete all the other request from all the targets including the PSA .Then you can run the repair full to PSA and then update the same to all the above data targets .

    In this way all the request would get successfully updated to all the data targets .

    Also going forward delta is also managed .

    Thanks

    Kamal

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2012 at 04:03 AM

    Hi,

    Yes in 3.5 selective loading is possible..

    You can update request by psa by psa request..you need to schedule it accordingly..

    also if you delete the latest delta request which is yellow for eg.. you can delete that yellow request,for some reason it is not completed..that means say timeout occured..when you will fetch next delta say 4# it should bring previous delta as well in repeat delta method..

    Thanks and regards

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Request#3 is green (but has 'no data'). If I delete it, will the next request #4 bring request #3 to PSA in this case?

      Thank you

  • avatar image
    Former Member
    Jan 10, 2012 at 02:53 PM

    Hi Olga,

    Should I first load request #1to DSO? and then update the Cubes? If yes, then how can I do this if i already have request #3 in PSA?

    : in BW 3.x you can load specific PSA request in target, there is not DTP, you have do using scheduler of PSA itself. So sure you can do it

    Next questions:

    1. What should I do with request#2 ( not in PSA)?

    :- Nothing, keep request#2 till you want it there...

    2. If I delete request #3 from PSA (it has no data), will the next delta load (it will be #4) pick up #3 too?

    :- Deletion of data in BW does not impact the Delta functionality, Delta is totally managed in Source system. So there is no impact on delta, once request/data comes to BW it will not take that data in next delta load.

    Regards

    Ganesh

    Add comment
    10|10000 characters needed characters exceeded