Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?

Is it like integrity check? Will we be able to find out any mis-match with the help of this?Kindly help me out in this.

Interview Candidate
Jul 29th, 2007
3
3142

Showing Answers 1 - 3 of 3 Answers

Ghungroo
Profile Answers by Ghungroo

Jan 30th, 2008

Both Data Provider SQL from report and SQL pasted in TOad tend to give the same results.But only thing is you can change the paraeters passed instatntly and get the output fast if u want to test huge amount of date

Thanks
Manju

sreya_1234
Profile Answers by sreya_1234 Questions by sreya_1234

Jan 31st, 2008

In the query panel, go to SQL button -> there you can find the SQL query generated for that particular data provider. use the same sql query and run it in the backend. the results should match with the report data or when you see Data -> view data -> results tab.

nishamakhija21
Profile Answers by nishamakhija21 Questions by nishamakhija21

Nov 10th, 2008

Hi,

The most difficult thing in BO is to Test, since we dont have any backtrace mechanism.

So to test the report the most important thing to know is the Logic of the report, i.e Business logic behind the report.
Thats y BO is called as analysis tool also.

By running the reports query in backend will not give u the answer whether ur reports funcitionality is perfect or not, its Illogical to run the query generated by BO itself at backend, since it will give u same result.

Hence,

To check whether ur reports data is perfect, or ur report gives u the data same as the clients requirement u need to test the report by creating Ur on logic query as per the queries requirment at backend. and for this u need to know the Business ligic and requirment of report.