Loading data Report to ODS

[Former Member]

Hello,

In my current CRM - BI implementation, there is one requirement to load data into ODS from BI Report. In detail: we have one big ODS where all customer infromation reside. Form that ODS, we create one report and this report is update once a day. Requirement is to load all updated data from report into separete ODS. Anybody has did similar thing before? and is there any documentation or detail steps how can I do that.

Thank you.

Md

[Former Member · Accepted solution]

Simplest solution to your case:

Report>APD>direct update DSO

Go in transaction RSANWB.Create an APD process where map Report with Direct Update DSO.

Refer My blog on similar thing :

/people/rakesh.kumar55/blog/2009/06/03/flexible-file-export-from-open-hubinfospoke-using-apd

Regards,

RK

[virenp_devi]

Hi,

You can also try transaction RSCRM_BAPI which loads data from Query and stores it in table or application server. Storing it in table will simplify your work as you can simply create generic datasource on the table and fetch the data. You can schedule the load to table from query anytime depending on u r requirement (periodic also).

Or create the file datasource and load data from application server location where you stored file using RSCRM_BAPI transaction.

Hope this helps.

Regards,

Viren

[former_member200211]

This message was moderated.