cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieving Data from Query

Former Member
0 Kudos

Hi Guys,

We want to rerieve data from a query but the issue is it has more than couple of millions of records. Can you suggest an optimum way of doing this?

Thanks,

Sudhir.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Bhanu,

Thanks for the reply. What I am needed to do is to find an optimum solution for retrieving data(million records atleast) from a query in which there are some complex calculations done and send it to other systems. I am not suppose store the data in ODS.

Thanks,

Sudhir.

Former Member
0 Kudos

Sudhir,

Using APD, not only u can store data from the query in BW itself, you can also send data to external CRM systems. This is the standard method to export data from a query.

Or, once you store the data in an ODS in BW using APD, use InfoSpokes to export the data into flatfiles etc.

Former Member
0 Kudos

Hi Gova,

Thanks for the clarification. I will surely try to do that using APD process to retrieve data from the query into BW itself.

Thanks,

Sudhir.

Former Member
0 Kudos

Hi,

Try out transaction RSCRM_BAPI.

former_member188975
Active Contributor
0 Kudos

Hi Sudhir,

Have you taken a look at the Analysis Process Designer (transaction RSANWB)? Take a look at this link:

http://help.sap.com/saphelp_nw04/helpdata/en/49/7e960481916448b20134d471d36a6b/content.htm

Using the APD you can store the query data in an ODS. You can also apply transformations like aggregation, sort or filter.

Hope this helps...