How do you test the performance of a report?

Answers were Sorted based on User's Feedback



How do you test the performance of a report? ..

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

How do you test the performance of a report? ..

Answer / sambamalla

write the query in wt u have data base,
that result compare the report.

Is This Answer Correct ?    2 Yes 1 No

How do you test the performance of a report? ..

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

Post New Answer

More Cognos Interview Questions

What is content store?

1 Answers   HCL,


what is logs in cognos

1 Answers   HCL,


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,


-----------------What is Determination Model?

0 Answers  






what do you mean by parallel execution of query?

1 Answers   Mind Tree,


How to create model and how to test model?

0 Answers  


i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

4 Answers   Tech Mahindra,


advantages of cascade prompt ???

3 Answers   iFlex,


explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

0 Answers   IBM,


What is the use of report studio?

0 Answers  


Categories