how can v do reconsillation b/w r/3 and bw

[Former Member]

hello all

i want to know how can v do reconsillation in order to check data in r/3 and bw

can you pls let me know

regards

balji

[Former Member · Accepted solution]

Hi,

I hope we will be checking data in ODS or cube in BW which gets data from R/3. Now to reconcile we need to create a remote cube and assign infosource which gets data directly from R/3. By putting both the cubes(basic cube which holds BW data and remote cube) in a multiprovider and develop a query on that we can compare the values.

Once again this type of reconciliation is based on clients interest and importance of reconciling.

Hope this helps you.....

[Former Member · Accepted solution]

hi avr

thanks for your info given,but i want to do this manually,i dont want to use by creating a remote cube?

regards

balji

[Former Member]

Hi balji,

there is an SAP HOW TO document:

www.service.sap.com/bi --> SAP BW old release --> Media Library --> How to guides --> guide list for 3.0 and 3.1 --> How to… Reconcile Data Between SAP Source Systems and SAP BW.

Ciao.

Riccardo.

[Former Member]

hi riccardo

thanks for your usefull info given,but i need to do reconsillation manually

regrads

balji

[Former Member]

Take a look to OSS Notes

576896 "Checks when PSA contains incorrect data" and

565086 (This note helps you to identify and solve errors with DataMart extraction and data inconsistencies)...

Hope it helps!

Bye,

Roberto

[Former Member]

Take a look here:

Hope it helps!

Bye,

Roberto

[Former Member]

hi roberto

thanks for your info

regards

balji