Dynamic Query Mode Scenarios
Date: 21/01/2014

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 protected]