how to test reports in businessobjects?

Answers were Sorted based on User's Feedback



how to test reports in businessobjects?..

Answer / akhil

To test a report we have to match the reports value with
actual value in database.
We need to follow following steps:
1. Note down the value displaying in report for particular
business object.
2. Calculate the value from Back end by using query analyzer
or Toad.
3. Match both values.

LET ME CORRECT IF I AM WRONG.

Is This Answer Correct ?    49 Yes 1 No

how to test reports in businessobjects?..

Answer / handy

To test the report the simply write the SQL query and test
it in the database, if copy and paste the SQL generated by
the BO in Report Panel and fires it in TODD then it gives
the same result. So to test report we need to manually write
the SQL and then test it in the database and compare whether
the result is correct or not.
For your kind information, Integrity Check is not used for
Universe testing and not for Report testing.

Is This Answer Correct ?    31 Yes 1 No

how to test reports in businessobjects?..

Answer / 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

Is This Answer Correct ?    24 Yes 1 No

how to test reports in businessobjects?..

Answer / pers

If we use the query of the report in the TOAD it would show
the same result. And the integrity check is only for
testing the universe and not for the report.
We would check the report by manually. As the report having
n number of rows we would not check for all and check it
randomly. This is the way to test the report.

Is This Answer Correct ?    18 Yes 5 No

how to test reports in businessobjects?..

Answer / obula reddy

if we are using oracle as a data source we can use TODD
(fornt end for oracle) to test the report . Take the SQL
statement from the SQL editor of Query panel and run the
query in the Todd .

Is This Answer Correct ?    28 Yes 16 No

how to test reports in businessobjects?..

Answer / mallik

The method specified above is a good technique.

The procedure below may add adequate value to the testing
the method descibed above.

First idetify the source tables based on the design
specifcation for the report, then verify that the right
tables/schema are selected as source(s) of the report, then
comes the condition(business rules transformation rules
etc) check using join conditions. If tester is able to
write a complex query himself (in many cases it may not be
fasibel to have person with that level of sql expertise)
and then verify for discrepancies. next comes the query
efficiency (optimisation) etc and finally the formatting
verification

The first step serves as analysis/design verification step
to detect in detecting analysis and design defects early
and helps in avoiding unnecessary test execution effort.

Is This Answer Correct ?    7 Yes 2 No

how to test reports in businessobjects?..

Answer / balajee

Copy the sql query from the report that is generated and
run the query in the DB,the data that came after running
the query should match with the report data.This is one of
the way of testing the repoerts

Is This Answer Correct ?    3 Yes 10 No

how to test reports in businessobjects?..

Answer / suganya. r

In BO intially to check the report, we go for Integrity
check . One button is there to check the integrity,parse
error, joins,loops and soon.
The second stage of testing involves testing the SQL query
of the report if it uses free hand SQL else we need to test
the universe which the report is using.

Is This Answer Correct ?    11 Yes 29 No

Post New Answer

More Business Objects Interview Questions

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


what is the syntax for aggregate awareness?

3 Answers   Exilant, i-Tree, Wipro,


what is stacked chart , Bar chart, Column chart?

1 Answers   Tech Mahindra,


What is object stores?

0 Answers  






HOW TO SPOT A HIERARCHY?

2 Answers   TCS,


@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,


5.what is slowly changing dimension ?

2 Answers   IBM,


Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,


WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,


What is the definition of derived table ?

2 Answers   JPMorgan Chase,


How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  


Categories