Master-Detail Optimization

[br54016]

Has anyone been successful at setting up master-detail optimization on a DQM package.  I have a report that I need to display a bullet chart for each row of a list report.  The report performance is unacceptable at this point.  I have tried to set the master-detail optimization governor which is supposed to cache the detail query.  I have done some research and found this on the IBM website:

Criteria known to prevent the DQM Master-Detail Optimization from working:
*The package governor (DQM) Master-Detail Optimization is not set to Cache Relational Detail Query
*The package is CQM
*The master-detail relationship has one or more parameters in the linkage. This optimization only support linkages that are data item to data item.
*The detail data items of the linkage must be included in the report object (hiding them is fine); they cannot merely be part of the Query Explorer query
*The Allow usage of local cache governor in the Framework Manager model is not selected when the package is published

I verified that I have each of these items covered but the detail query is still being sent to the DB for each row.

Thanks,
Brad

[schrotty]

Try this :

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


Mfg Schrotty