Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you please send me the migration related issues .
can anybody tell me about complicated object you have created
U r project in which stage in implementation?
Explain in detail about type 1?
What is a bo repository?
Explain the difference between union and group?
When to use local filter and when to use global filter?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
what are the day to day activities of BO administrator ?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain about alerts in bos, under what situation we need to use alerts?
How many universes can be created in a project?
Explain about a tricky situation for which you found a very simple solution?
Explain what task is 98% of the required work of a business analyst?
How to execute the plsql procedure from the report by clicking with mouse?
