How do you test the performance of a report?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by the term 'aggregate cache'?

745


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1774


What is metric store database?

742


Diff b/w Crossproduct and Outerjoin?

2024


What is the difference between a cascading report and drill through the report?

926


What is Bitmap Index?

812


What DB View and Bus View?

1768


What is the difference between a data mart and a data warehouse?

765


what are the special features in cognos reportnet?

807


What do you mean by Drill down and Drill Up?

739


What is the advantage of using shortcuts?

835


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1835


Is it possible to join multiple Databases in a Catalog?

855


What is defined as catalog and types of catalogs in Cognos?

786


Define datastores in cognos?

716