Skip to Content
0
Former Member
Jan 15, 2009 at 10:31 PM

Extracting only one request out of two or more requests from PSA

55 Views

Guys,

I'm trying to extract data in BI 7 using DTP in Delta mode.

In DTP we have option to select

1) Only Get Delta Once

2) Get all new data request by request

Consider my scenario,

.......................................................................FIRST ODS (3.5)

..................................................................... /

..................................................................../

R/3 --> PSA --> BASE ODS( 3.5) -> PSA ->

....................................................................\

.................................................................... \

.................................................................... SECOND ODS (7.0)

1) Data gets loaded from R/3 to Base ODS

2) From Base ODS it gets loaded to FIRST ODS which is a 3.5 version load (By this time, data is already loaded in PSA)

3) Next, data gets loaded from Base ODS to PSA and then using DTP to SECOND ODS.

4) At the time of DTP execution, it loads two requests in my SECOND ODS because I selected 'Get all new data requsts by requests' and since there are two requests now (one from FIRST ODS load and second from Infopackage to SECOND ODS load).

5) Since I have a ODS it is going to overwrite the records, but I can see two requests sitting in my SECOND ODS.

I would like to extract only single request from Base ODS to SECOND ODS.

Is there any option (either in DTP or somewhere else) where I can specify that the system should extract only ONE (latest) request from available PSA's.

Please provide inputs if u have come across this kind of scenario.

Thanks !!