Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers