Answer Detail: RE: Improve Report Running Performance

GeekInterview.com > Interview Questions > Data Warehousing > Reportnet

Print |

Question: Improve Report Running Performance

Answer: How would you be able to improve the performance in running a report?
i) Basically in order to tune the report what are theproperties you can set?
ii) Some of the reports are running in Dev (Cognos environment) against the Prodution database(OLTP) where
The performance is taking a hit. Is there any mechanism in Cognos where-in we can improve it?

February 02, 2008 06:01:08	#1
praveenj6	Member Since: December 2007 Total Comments: 6
RE: Improve Report Running Performance
To increase the performance of a report while running - set the governers -joins shuld be less -Aggregate table should be there while using group functions there will be a dead lock while running a report against the OLTP database.so better not to do this

Back To Question