how to load data from one Infocube to another request by request using DTP

[Former Member]

Hi All,

I have a scenario where we are maintaining backup Infocube B for Infocube A. User loads data from a flat file many times a day in different requests. We need to maintain backup of the Infocube A on weekly basis. i.e data to be refreshed with delta update from cube A to cube B. There are some situations where user deletes some of the requests in Infocube A randomly after use. Will this change effect in back up cube B when performed data refresh from cube A to cube B. i.e. this functionality is similar to reconstruct in BW 3.5. Now we are running on BI 7.0 SP 9.

Can anyone answer this ASAP.

Many Thanks,

Ravi

[Former Member · Accepted solution]

You cannot load request by request, " Get Data By Request " DTP loads request by request on " First In First Out " basis. You can run some Pseudo/Fake DTP's if you dont want to load data from a particular request.

If the user deletes a request from Cube A, it wont be loaded to Cube B but if it is already loaded in Cube B and later the user deletes the request from Cube A you have to delete the request frm Cube B. Inorder to monitor request by request run DTP with " Get Data By Request set.

[Former Member]

Hi,

In DTP extraction tab you can find the "Get data by request ".

Prasad

[Former Member]

HI,

I understand the functionality you explained. But, where is that option. I did not find that in DTP. Please let me know.

Regards,

Ravi

[Former Member]

Change the Update Type to Delta to find it .