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
Try this :
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