BY NIKITA ATKINS, PRINCIPAL CONSULTANT
As some of you may have discovered, while Dynamic Query Mode (DQM) has a positive impact on report performance, it does have it's challenges, especially when trying to create traditional analysis style reports.
IBM has a published document that presents some of the common problems encountered when creating reports in DQM. Note, this is a general document and does not cover how to model TM1 cubes when using DQM.
I have found it handy when trying to understand some of the errors created by reports that I have created using DQM.
The document ""IBM Cognos Proven Practices: IBM Cognos 10 Dynamic Query Mode Migration Scenarios"" can be downloaded from ibm.com/developerWorks or if you need further assistance please contact me at email@example.com