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
Difference between b.o 5.1 and 6.1b?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What task is 98% of the required work of a business analyst?
what is xcelsius architecture?
When to use local filter and when to use global filter?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
can anybody tell me about complicated object you have created
Explain what is the difference between slice and dice and cross tab report?
What are the steps to be taken to schedule the report?
How to schedule the report in b.o?
8. How much supervision have you typically received in your previous job?
Explain when to use local filter and when to use global filter?
What is thumbnail?
Explain the data types present in bo and what happens if we implement view in the designer and report?
