Uploading of historic data into BW from legacy

77 Views

Hi all,

I would like some inputs from all the BW experts in the forum.

Here is the scenario:

My client has all the data from 2001 in R/3 and BW. But prior to 2001, the data was maintained in a legacy system. Now my client wants to move the data prior to 2001 into BW and use the data for reporting purposes. What are the possible options to move the data into BW?

The data in legacy system is not as descriptive and elaborate as in BW.It doesnt have all the attribute fields.

So,do i need to create a new cube, with the availiable fields and upload the data?

Is there any way that i could upload the data in the existing cubes?

Which one is the appropriate method of uploading data,DB connect or flatfile upload? there are approx. 10 million records

Any insight would be appreciated.

Thaks in Advance.

Mav.