IBM Cognos Dynamic Query Analyzer Version 11.0.0 User Guide introduces the features and functions of the product.
IBM Cognos Dynamic Query Analyzer Version 11.0.0 is an IBM query visualization tool. It lets report administrators visualize and troubleshoot query logs generated when dynamic query reports run in IBM Cognos Analytics. The guide covers getting started, Aggregate Advisor, analyzing query log files, and DQM server logs, with accessibility and troubleshooting appendices.
Cognos Dynamic Query Analyzer also includes Aggregate Advisor, which analyzes the performance and structure of dynamic cubes and suggests aggregates to improve cube performance. The document describes Aggregate Advisor options and results, and explains how to run Aggregate Advisor and work with query log files. It also lists new features in versions 10.2.0, 10.2.1, 10.2.1.1, and 10.2.2.
| Version | 11.0.0 |
|---|---|
| Tool type | Query visualization tool |
| Included tool | Aggregate Advisor |
It is a query visualization tool for visualizing and troubleshooting query logs generated when dynamic query reports run in IBM Cognos Analytics.
It analyzes the performance and structure of dynamic cubes and provides suggestions for creating aggregates to improve cube performance.
Query log files are no longer shown by default; click Window, Analyze logs to view them.
It is intended to help report administrators analyze reports and find performance bottlenecks in dynamic query reports; modelers and administrators can use Aggregate Advisor.