Tag Archive for: Dynamic Query Mode

Previously in our “What’s New in IBM Cognos 10.2” article, we touched upon the new IBM Cognos OLAP capability known as Dynamic Cubes. In this article, we will discuss what it is, when it is useful, and how to put it into practice. Read more

In September, IBM introduced Cognos version 10.1.1, the latest update to Cognos 10. Among the significant enhancements in the software is the ability to Dynamic Query Mode with relational databases.

Dynamic Query Mode (DQM) is an intelligent data caching mechanism which can dramatically improve the performance of OLAP style queries. With the prior version, DQM supported cubes built from TM1, Essbase and SAP BW. With version 10.1.1, IBM Cognos adds support for Microsoft SQL Server Analysis cubes, and the most common relational databases, specifically DB2, Netezza, SQL Server, Teradata and Oracle. Read more