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
What is the difference between user and versatile user?
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 more than 1 metric be applied on an analytic in business objects?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain the difference between union and group?
what is universe null
What task is 98% of the required work of a business analyst?
What is the difference between business requirement document and use case document.
any difficulitis have you phase while creating bo reports and how did u solve it
Explain is there any other repository domains rather than universe, security, document?
Explain what task is 98% of the required work of a business analyst?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
what will be the contents for a functional requirements specifications
what is xcelsius architecture?
What are all difference between business objects 6.5 and xi r2?
