How to Improve performance on cognos Report studio

Questions by Ashok Doddapaneni

Showing Answers 1 - 5 of 5 Answers

Bhaskar Jha

  • Nov 8th, 2014

To improve performance on cognos report studio is to turn-on reuse feature in report studio.

After trun-on reuse feature and run a report for first time it will fetch the data from the base table, and when you run the same report it will fetch the data from cache.

  Was this answer useful?  Yes


  • Nov 21st, 2014

Also , you can move the filters from report level to FM level.
Schedule to run the reports in off peak hours

  Was this answer useful?  Yes


  • Mar 15th, 2015

we can check to see if we can change or add indexes on the tables we are pulling the records from.

  Was this answer useful?  Yes


  • Sep 11th, 2015

Hi Bhaskar thank you for the tip. How to turn on this feature in 10.2

  Was this answer useful?  Yes

lakshmikar lebaka

  • Aug 9th, 2016

1.Governor settings
2.Avoid unnecessary functions like in, between, like operators 3.Execution concurrent method
4.Avoid complex calculations
5.Local cache-yes
6.Parameter information-yes

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions