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&#8242;Highlights in red
color if any changes in cells
Else
cell.Interior.ColorIndex = 0
End If
Next

set objExcel=nothing

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2342

---

explain in detail about type 3?

1021

---

How to create Index to the table in the universe designer and how it improves the Query performence

2553

---

How to execute the plsql procedure from the report by clicking with mouse?

1135

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2006

---

Explain how to schedule the report in b.o?

1054

---

Is there any other repository domains rather than universe, security, document?

1048

---

Explain what is the difference between business requirement document and use case document.

1030

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3580

---

Differences between business objects and web intelligence reports?

1230

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1881

---

How many universes can be created in a project?

1054

---

Explain which versions are used in the bo dashboard work?

1097

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1274

---

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2915

---