Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: koolbachi on 11 Feb 2006 04:30:27 PM

Title: performance tunning
Post by: koolbachi on 11 Feb 2006 04:30:27 PM
Hi ,

When i am working with billions of data, i am not able to generate the report.

After running for  7 to 8 hrs not able to generate report.

But with limited data i am able to generate the report.

Thanks
Title: Re: performance tunning
Post by: mikegreen on 11 Feb 2006 07:51:34 PM
So what is your question?
Title: Re: performance tunning
Post by: koolbachi on 14 Feb 2006 06:41:38 PM
Hi,

I want to know how to reduce the time consumption?

how to tune the performance

thanks
Title: Re: performance tunning
Post by: mikegreen on 14 Feb 2006 07:54:04 PM
Well, that is a very broad request.. probably BEST handled by finding a consultant to come in and do it for you if you are not familiar with data modeling, Cognos ReportNet, and your database system....  If you really are dealing with a billion row system, you need to talk to your DBA and find out how to query the system. 

Anyhow... First things I would look at -
How much time does CRN take vs the Database to return the query? Run the SQL in your native RDBMS query tool then compare to how long it takes the report to generate in CRN... CRN should only take a few minutes (maximum!) to make a report.

Try getting everything you can to be done in your database system.... make views/datamarts of aggregated data to only let CRN see the data it needs to make your reports/charts/etc.



Text only | Text with Images