This is a question on approach/design, rather than technical problem.
We loaded the Logistic (SD, MM, PM and PS) information from SAP R/3 into BI 7 on daily basic via standard and non-standard DataSource. These are the transactions data posted in R/3, these information is then transform (some calculation via routine) and loaded into ODS then to InfoCube. Report is then created from the InfoCube.
Question is how can we ensure the data displayed on the report (or in PSA or ODS or InfoCube) is reconciled and in sync with its source system in R/3?
In other word, how can you ensure the data loaded into BI is correct and accurate?
Have you come across the same scenario?
Please advice, thank you.