Technical
IBM Cognos 10 Dynamic Query Cookbook
Cognos Dynamic Query Mode (DQM) is an intelligent data caching mechanism which can dramatically improve the performance of OLAP style queries over a range of OLAP sources, such as SAP BW, Essbase, Analsys Services and TM1 and also over Relational Sources.
This document provides a single point of reference for techniques and product behaviors when dealing with the Dynamic Query Mode delivered with IBM Cognos 10.
Dynamic Query Mode is an enhanced Java-based query mode which offers the following key capabilities:
- Query optimizations to address query complexity, data volumes and timeliness expectations with improved query execution techniques
- Significant improvement for complex OLAP queries through intelligent combination of local and remote processing and better MDX generation
- Support for relational databases through JDBC connectivity
- OLAP functionality for relational data sources when using a dimensionally modeled relational (DMR) package
- Security-aware caching
- New data interfaces leveraging 64-bit processing
- Ease of maintenance with query visualization
Â
The IBM Cognos 10 Dynamic Query Mode can utilize the following OLAP data sources as reporting databases:
- Oracle Essbase
- SAP BW
- TM1
- Microsoft SQL Server Analysis Services
For these OLAP sources, IBM Cognos 10 uses the same data source connectivity install procedure for both the Dynamic Query Mode and the Compatible Query Mode.
Cognos 10 Dynamic Query Mode can utilize the following relational data sources as reporting databases:
- IBM DB2
- Netezza
- Microsoft SQL Server
- NCR Teradata
- Oracle
ibm cognos 10 dynamic query cookbook small.pdf
Â
Posted in:
Need help with TM1?
We're here for you