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.
I would suggest that you create a new ODS Object or InfoCube for the old data. I would start with the model of the new data and make changes as the data dictates. You can then create a MultiProvider on the new and old data for comprehensive reporting.
With regard to the technology for getting the data. I think the decision is based on a couple of considerations:
1. DB/OS of the system where the old data resides
2. How much transformation is required for the data to be loaded.
Number 1 will tell you if DB Connect can be used.
Number 2 will tell you if you need to create simple or complex transformation routines or if it would be better to transform the data before getting to SAP BW.
DB Connect would not be the best solution if you have massive transformation requirements. It may be better to do this on extraction to a flat file or ETL tool.
If you chose flat files, I would split the files in smaller chunks of data for loading. It is easier to manage and achieve parallelism that way. Also if you can presort the flat files, it is faster too!
I hope this helps,