How to test the BO reports

[Former Member]

Hi Experts,

I would like to know how to test the reports in BO,

Is there any procedure or process for testing in BO.

[Former Member · Accepted solution]

Hi Ravi Shankar,

There is no standard defined procedure or process to test BO reports.

You can make a checklist of your own covering the aspect your want to test and write test cases accordingly.

E.g.

Consistency in the Font Size and Font used across the report and reports

How the report output is in different formats like Excel, PDF

Page Setup as per user requirement

Report name, page numbers, refresh details on all reports / pages

Data formats, decimal places, currency symbols, etc.

Prompt settings like default , optional, LOVs, mono, multivalue etc

Let me know if this helps

Sujit.

[Former Member]

Hi Folks,

            Extension to this topic, after generating my Webi Report I want do data validation test as part of my UNIT testing

             1) If the report built on top of any RDBMS Databases like SQL or Oracle we can go back to tools like TODE and we can run our report sql against Database to cross-check the data

             2) Here my question is what if the report built on top SAP BW in which way we can do data validation testing?

Many Thanks

Kind Regards

Raki

[Former Member]

Hi,

If the report is built on SAP BW then the validation should be done for BO report data against BW Query analyzer.

Give the same filters for BO report and the analyzer report and check whether the data is matching. Data should match.

Thanks & Regards

Giri

[ravi_chandra3]

Hi

whenever u execute a report the SQL statement will be generated , now copy that SQL statement and then copy that in THE TOAD tool  or in oracle  . and check the data between them .

Hope u got it,

Regards,

RaviChandra

[swati_patil4]

Hi Ravishankar,

Yes, as Sujit says there are not standard procedures/process available for testing of BO reports

If you are testing new developed Reports you can consider Formatting of the reports as given by user. As well as need to test the reports' data. Whether report is giving the correct data or not.

If you have reports in existing system and these reports are migrated to the new version BO System or the system where service packs/fix packs applied in that case you can look into the following things
1. Compare formating and data in existing and new system
2. Check for merge dimension objects in the report.
3. Check for Block level filters
4. Check for variables used in the report.

It is easy to test the report's data when you export report to PDF/Excel and compare the data for different versions.

Please let me know if you have any queries.

Thanks,

Swati