How do you test the performance of a report?
Answers were Sorted based on User's Feedback
Answer / cognosvij
generally we test the performance by following way.....
in cognos report studio we get the cognos generated Query
copy that query and run it in your Database
and run the same in report studio and compare the time ....
thanks,
vij:)
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sambamalla
write the query in wt u have data base,
that result compare the report.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / naga sudha
First
Run the report with Excel as Run option and take that data
in the first page of the Excelsheet.
Second.
Generate the sql of the report for the same parameters to
be filtered in the report and execute that sql against the
database environment....Point to be noted both should be
Dev or Test or Prod...Then take that data into the second
sheet of the excel,
Then Apply Condition Format of the Two excelsheets like
SHeet1 1*1=Sheet2 2*1 Then Green Else some Red.
Then u can able to Find the presentation of the data with
respect to the report and against the database in the
excel sheet.
Regards,
Sudha
| Is This Answer Correct ? | 0 Yes | 5 No |
What is Portal Tab?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
What is meant by Reportstudio shortcut?
what are the special features in cognos reportnet?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
what is Governor settings in cagnos?
-------------What is Coditional Prompting?
What is Local Cache and how does it help in performance tuning
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?