Is there any significance of testing the BO report

Hi All,

Is there any significance of testing the BO report by geting 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.This sort of testing eats most of our time.

vinisayshai @ yahoo . co . in

[b]Question asked by visitor Vinithra[/b]

Some time we need to test the BO reports, to ensure the data was pulled currectly.
Like if the universe is not built properly.. then report may not be having the proper data as per rewuirement.

So, we need to cross verify the report data with DB.

In Xlcius reports.. Developer may or may not implement the queried according to the requirement.
Ex: If the data needs to be displayed based on the selection like
Last 7 days, 30 days, 90 days, 120 days oe 180 days..
if the data needs to be displayed day wise for 7 days... week wise for 30, 90 days and for remainig monthly wise then.. tester needs to bouble sure the the data pulled is currect based on the selection