Answer Posted / shivakumar auradi
Well testing a Reports,
what all above said are partially correct.
follow the below steps for successful report testing:
1: Identify the Database table Names.
2: Identify the Join condition for which data is coming.
3: write the SQL code for the particular Report.
4: Count the Report data and SQL data ( i.e. Count rows )
5: If count matches reduce the report size by filtering it
through Excel.( generate excel sheet for the reports and
filter according to unique value or country wise etc.)
6: If you are familier with Automation tool use the tool to
compare 2 excel sheets.
7: if not download excel comparision softwares and compare
it.
8: I know comparing around 8000 or 9000 records are not
possible. so use excel comparison tool.
below is the QTP code for excel comparison. use this to
compare 2 reports each cell value.
////QTP code for Excel Comparison.
Set objExcel = CreateObject(“Excel.Application”)
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open(“C:Documents
andSettingsmohan.kakarlaDesktopDocs1.xls”)
Set objWorkbook2= objExcel.Workbooks.Open(“C:Documents and
Settingsmohan.kakarlaDesktopDocs2.xls”)
Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1)
For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorksheet2.Range
(cell.Address).Value Then
cell.Interior.ColorIndex = 3′Highlights in red
color if any changes in cells
Else
cell.Interior.ColorIndex = 0
End If
Next
set objExcel=nothing
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
how get the grand total in master-detail report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is object stores?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain in detail about type 1?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
In banking domain how many Fact tables,Dimension table are present?
Explain about a time when you discovered a more efficient way to do a work task?
what are the tables used in health care domain project and columns used in report?
What is aggregate table and aggregate fact table ... Any examples of both?
Can you please send me the migration related issues .
