COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: samiar784@gmail.com on 18 Sep 2015 01:47:18 PM

Title: Master detail relationship and report performance
Post by: samiar784@gmail.com on 18 Sep 2015 01:47:18 PM
Hi All,

I am using a relational database.I have a cross-tab report where I have 2000 records(2000 region id's and revenue). I have used Master detail relationship between my crosstab  and a chart in order to display the graphical representation for each row of data. But, this reduces the performance drastically..Is there a way where I can bring it down to some seconds

Thanks,
Sameena
Title: Re: Master detail relationship and report performance
Post by: schrotty on 24 Sep 2015 05:40:06 AM
Try this Proven Practice:


http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html
(http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html)


mfg
schrotty