COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => ReportNet Administration => Topic started by: firefee on 06 Oct 2006 01:27:51 AM

Title: ReportNet performance
Post by: firefee on 06 Oct 2006 01:27:51 AM
Hi,

my problem is that our reports are runnig very slowly!

Do you have any ideas, how can I make them faster ?
Where can I set the native SQL for the queries I use ?

Thanks

Firefee

Title: Re: ReportNet performance
Post by: COGNOiSe administrator on 28 Mar 2007 04:51:02 PM
In ReportStudio, you click on the Show SQL elipsis button, then you click convert to SQL.
Title: Re: ReportNet performance
Post by: sir_jeroen on 28 Mar 2007 05:31:51 PM
Do you see any strange SQL Codes in your reports? Are you using a lot of local processing functions? You'll have to examine your reports and also take a look at the indexes on your tables...