How many ways we test the universe & Report?

  • Interview Candidate
  • 8
  • 10106

Showing Answers 1 - 8 of 8 Answers

Parthasaradhi

  • Feb 7th, 2006
 

By doing integrity check we can test universe & By coping report query and run in backend(oracle,sql server...) we can test the data by comparing both.

  Was this answer useful?  Yes

sithu

  • Mar 25th, 2006
 

just do the integrity test, it will find out everything and tell youCheers,Sithusithusithu@hotmail.com

  Was this answer useful?  Yes

venkatsiri

  • Sep 15th, 2009
 

Universe can be tested by using Integrity Check weather to find out we have any Loops created while giving joins to tables, and also we can check cardinalty ( 1- m , m-1 relationship ) and Divergency (like tables with out joins).
Coming to Reports we can Check by running the same query in DB and compare the DB data with report data like no. of records and values.

shalabhsingla

  • May 12th, 2010
 

Universe Tests -

Integrity checks for the major structure problems of the universe which include loops, missing joins, conditions, cardinalities, incorrect object definitions, need for context etc.

In addition to this a Designer should manually check for Trap Situations - Fan and Chasm. These situations are not easy to trace and result in incorrect resultset of reports pointing to the universe.

Report Testing -

In addition to banging the resultset of underlying database query of BO with the actual query which should have resulted the same recordset in database a Report Designer must validate the structural correctness of report which includes a check of all variables created for the report behaving in desired manner, sorts done correctly, sections applied in proper way, column breaks and page breaks. Also check that all aggregations should yield correct totals. When using graphs more observatory testing is essential.

  Was this answer useful?  Yes

Arjit Dwivedi

  • Aug 18th, 2011
 

by checking the integrity and the execution time of our reports and universe design

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions