Master detail relationship and report performance

[samiar784@gmail.com]

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

[schrotty]

Try this Proven Practice:


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



mfg
schrotty