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

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

999

---

Can Bo generates the Report from the cubical data Explain?

2031

---

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1941

---

Can we configure two instances of CMS pointing to two different CMS system databases?

2027

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1035

---

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

1044

---

What is a bo repository?

1041

---

What is the functional & architectural differences between business objects and web intelligence reports?

2406

---

What is the difference between slice and dice and cross tab report?

1040

---

When to use local filter and when to use global filter?

993

---

Explain in detail about type 1?

1598

---

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10879

---

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6870

---

What Is The Difference Between Oltp And Olap?

1117

---

in sap bi we have wad, then why we go for sap bo

3377

---