Question:
Hello,
BW Experts :
I have to create reports for Comparing of data loads from R/3 to BW(Infocubes).Please advise me how should i start or if some one developed some reports CODE of report will greatly help.
Please help me.
Best Regards,
Yoko.
Answer:
Hello,
BW Gurus:
Can you please answer my above question.
Please help me.
Regards,
Yoko
Answer:
What datasources are you using? Z custom tables or flat files? Is the extractor an ABAP program or SAP standard datasources that use Function Modules?
Answer:
First make sure your data model (cube or ODS) can suport this type of query:
1. Add a new time characteristic ZDATE (reference 0DATE).
2. Update this field with the load date of the extract
Should be a internal date field that represents the infopackage
load date, ie extract date.
3. In your queries use restricted key figures by ZDATE.
4. Create a formula that computes % variance from one load date
to another
Next make sure the date is gets in the communication structure:
1. In your infosource you can derive ZDATE by the extract date.
2. Maintain the update rules and map ZDATE.
Just a few thoughts. This should not require code, other then the transfer rule for the additional characteristic ZDATE.
Answer:
I believe there is a "How To" paper on comparing PSA to InfoCubes. This might be what you are looking for?
Answer:
Its not comparing PSA and infocube as both r in BW
its from R/3 and BW.
Dont wanna pull this thread as its discussed in this forum earlier and debated by CHC,EL,Stephen and others.
pliz search the forum
Chetan
nJOY SAP.
Answer:
chetan,
You are true its comparing between R/3 and BW.
I found in forum but no results.Please advise.
Thanks,
Yoko
Answer:
Man i know CHC,EL stephen got lots of posts atleast could have tried on mine(CHETAN) post searching very few
Below is also a search on CHETAN
/forums/viewtopic.php?p=115728&highlight=#115728
Chetan
nJOY SAP
Answer:
Well Thanks chetan for the link.
But mymanager is asking me to write an ABAP program which is a Report of data compariaon between BW and R/3.
I hope i should read data from PSA and IC and compare b/n them.Please do confirm is my approach is right.if you have any good ides please do suggest me.
Regards,
Yoko.
Answer:
Well, you could write an ABAP report to compare the PSA data to R/3. (I don't know how in ABAP you span systems, but I am sure you can.)
You could also do an InfoSet (ABAP) query against the PSA data, and also an InfoSet (ABAP) Query in R/3 against the R/3 tables and compare the two reports.
However, this is a big effort, when it would probably be easier to run comparisons at the SQL level in (if using MSSQL) Query Analyzer.
There is definately no documentation or white papers by SAP which cover data validation between R/3 and BW. Comparing ODS/Cube data against PSA data is only helpful from the standpoint of troubleshooting load or routine (technical) problems.
If you are comfortable or have the ABAP resources to write the report(s) then you can do that.
The question(s) you have to ask yoru manager is (1) What is he looking to compare? and (2) Why is he looking to compare?
For (1):
If he is looking to have an ABAP report on R/3 which goes down to the detail level to be able to compare line by line what is in the PSA/ODS then I would say you DON'T want to do that.
If he is looking to see a quick comparison (snapshot) of total sales $ by month over the last few months to see that BW and R/3 jive, then you can do something like that. The thing you have to make them aware of is that unless that snapshot is taken in R/3 at the time the data is transfered to BW it will NEVER be in sync, as the R/3 system is continually changing.
And if you are using the delta mechinisms in the standard extractors it makes it harder to capture that snapshot.
For (2):
If a functional group suspects the data in BW or R/3 is incorrect for their group, it would be better to provide them work with a technical person who knows their area in determining what is wrong (R/3 or BW, and if so where.)
In our case, 99.9% of our data issues have always been that R/3 data is incorrect. We have a technial DB guru who works with our functional area people to determine where things are incorrect in R/3 so that they can be corrected.
- Stephen
Answer:
Well ur approach is rite YOKO for PSA and IC compare not R3 and bw
But m not sure ur managers gonna be convinced depends on u to convince him and trust u and utmost BW.
Still like to have more insights on my friends CHC,EL,Stephen
Good luck
Chetan
nJOY SAP
Answer:
Hello,
Buddies Thanks a lot for a wonderfull response.
I really appreciate that and will convince my Manager.
Regards,
Yoko.