Skip to Content

What is the Best way to integrate SAP data with Old system data without BW ?

May 08, 2017 at 02:35 PM


avatar image
Former Member

Hi Experts,

We working on BI Project and the customer do not have Business warehouse, they have Historical data on CSV file and they want to merge it with SAP data to report on them Both, to compare the sales them among years, I am afraid to join the 2 data sets (SAP Actual data and CSV file) Using Information Design tool Because of the data Duplication of the values like this image:

the X (Composite key) repeated for each date value because it matches the join condition, and i cannot join by the date because it will never matches.

Please any help to make this work, i will use Crystal report or Webi for reporting,

duplicated.png (12.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers