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

[former_member191571]

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 !!

[Former Member · Accepted solution]

Hi

Skip step 3. You do not need to load from the BASE ODS to the PSA, as the load from the BASE ODS to the FIRST ODS has done that for you.

The other option is to delete the contents of the PSA prior to running the second load, e.g.

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) Delete all requests in the PSA

4) Load from Base ODS to PSA and then using DTP to SECOND ODS.

Hope that helps.

Chami

[former_member191571 · Accepted solution]

Thanks Chami,

Usually we get a option to select Only One request in DTP, but somehow I'm not getting that option.

What could be the issue?

[former_member191571 · Accepted solution]

I got the option to select only one request.

When you click on "Get All New Data Request by Request", you should get another checkbox with "Retrieve Until No More New Data", just unselect this check box and "Get only One Request" option would be displayed.

If you don't get it, refresh the session.... /nrsa1....it works

Thanks for your help