cancel
Showing results for 
Search instead for 
Did you mean: 

comparing two data and generating a report

Former Member
0 Kudos
66

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

Accepted Solutions (0)

Answers (2)

Answers (2)

vinay_lohakare5
Contributor
0 Kudos

Hello Sappy,

Below are the options:

1) Create 2 seperate queries one on the Flat file load cube and other on the ECC load cube.

    Run the BEx queries

     a)without any selection it should return the same number of records form both the queries

     b) give the same selection and run, should return same result

2) You can do it by writing the logic at the backend. In the end routine lookup the DSO to check if the records anr present , if present then you can flag the record as yes else no.

3) Create a Multi provider and check if the KFs from both the cubes have same values using CKF.

Thanks,

Vinay

kr_pavankumar
Contributor
0 Kudos

Hi

ECC --> DSO(write-optm) --> Cube

File  --> DS0(write-optm) --> Cube

First load the data of ECC, then while loading the file data do a lookup from the DSO of ECC for the combination(Whatever the fields would like to compare) :

1. Product ( eg. APPLIANCE)

2. Product Group (eg. BLENDER)

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

4. Shipment option (eg. LAND/AIR)

If u get a record for the above combination then populate "YES"  in a field (say STATUS) or else NO.

On the top of these two cubes create a multiprovider and do the report.

Hope it helps

-- KRPK.