Multiple master detail relationships in a list report causing performance issue

[xyz]

Hi Gurus,

I have list report, which have multiple columns and almost each column has a micro chart, bullet chart or a list report inside these columns and these are joined to main report using master detail relationship, datasource is SSAS cube. How will i improve the performace of the report, as report is taking almost 2.7 minutes to 3 minutes depending on the filter applied on the main list report. If data is more in the main list then execution time of the report is more than that.

I tried the IBM proven practices but I guess this is for relation datasource

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

Can you guys, help me how to improve the performance of my list report. Your help will be much appreciated.

Thanks & Regards,
xyz

[xyz]

Paul or Some one,

Can you guys help me on the same, as this is high priority and I could not get help any where about the peformance improvement for master detail style reports running against SSAS cube data source.

Your hlep will be much appreciated.


Thanks & Regards,
xyz

[xyz]

Paul or Some one,

Can you guys help me on the same, as this is high priority and I could not get help any where about the performance improvement for master detail style reports running against SSAS cube data source.

To improve the performance of this type of reports, we have been communicated by IBM support and Cognos experts to go for DQM. We have configured and published the package with DQM.

Now the problem I am facing is DQM is erroring out for Case statement condition used in one of my dataitem.
Does any one know, what could be the alternative for case statement. I assume DQM is pushing MDX to the query engine, which is not allowing case statement.




Thanks & Regards,
xyz