Extraction

[Former Member]

Hello all,

i would like to know how can we know in BW that the data extracted from the R/3 system is correct.

Also how can we know that the query result has the right data.How do we do the testing.

How do we do unit testing in BW.

[somnathkumar · Accepted solution]

To check whether the data coming from R/3 is correct or not, you can test the datasource in R/3 through transaction RSA3.

1. You must know how the data that you are trying to extract is created.

2. You must know all the different scenarios in the process above.

3. Create data through this process in such a way that all the fields in your datasource extract are populated.

4. Run the extractor through the RSA3 and compare the data extracted with the expected results.

For query results also, you must have a test case for every business scenario and how the data should appear in the report. There must be a test case for every characteristic value, update rule and keyfigure value.

Then create data in R/3 and upload it. And run the report. Is the results as expected? If not, you have to debug the different parts of the extraction logic to find out where the erroe is.

[Former Member]

Hi Denzil,

I think your request might be satisfied by this section in www.service.sap.com/bw -> SAP BW InfoIndex -> Data Quality ->

· BW Consistency Check Guideline 3.x (pdf)

· Data Cleansing / Data Quality in SAP BW (ppt)

· Data Validation and Error Handling BW 3.x (pdf)

· How to... Validate InfoCube Data By Comparing it with PSA Data (pdf)

· Notes List Data Consistency 3.x (htm)

Hope it helps!

Bye,

Roberto