comparing two data and generating a report

39 Views

Hi,

We have an ECC data which is to be compared with an Excel Sheet.

We are planning to get both in BI. And then to have BEx report on it. This report will compare the two data and will result output as compliance or non compliance.

Now, The ECC data has say following fields

1. SO (eg. 2002)

2. Product ( eg. APPLIANCE)

3. Product Group (eg. BLENDER)

4. On time delivery Commitment ( eg. Y/N)

5. Shipment option (eg. LAND/AIR)

And Excel Sheet has say following fileds

1. Product ( eg. APPLIANCE)

2. Product Group (eg. BLENDER)

3. On time delivery Commitment ( eg. Y/N)

4. Shipment option (eg. LAND/AIR)

How to compare these two data? ( these can be loaded into different cubes and then create a multiprovider) How to compare Char (like Y/N) in BEx?

While loading the data, do we need to create seperate Z InfoObjects for both the data?(like, ECC On time delivery -> ZOND1 and from flat file On time deliver -> ZOND2 and then compare in query? )

Please help!

Thanks