Reconcile ECC data with BI

[Former Member]

Hi,

Can anyone please tell me how to reconcile ecc data with bi data targets

1.ECC data with PSA as well as data target--full load

2.ECC data with PSA as well as data target--delta load

     we have one data source and multiple targets(1 DSO&CUBE) so the transformations is different for different targets but the data source is same for 2 targets,how we reconcile ECC data PSA and data targets..

how to check correct data is loaded into data targets (DSO&CUBE) with the data source data (ECC data source)

Thanks

Shankar

[Former Member · Accepted solution]

Hi Shankar,

We have done such a thing in our project. Approach for doing this was we had is we created a program in BW system which takes input from user and then though RFC connection program connects to Source and in Source FM runs in Source gets selection from Program in BW and then gets executed to bring data in BW program and then compare aggregated data and match it.

Regards,

Ganesh