The IBM Cognos Dynamic Query Analyzer Version 11.0.0 User Guide describes the features and functions of the product.
This IBM guide covers Cognos Dynamic Query Analyzer version 11.0.0, a query visualization tool that lets report administrators view and troubleshoot query logs generated when dynamic query reports run in IBM Cognos Analytics. It also describes the aggregation advisor, which analyzes the performance and structure of dynamic cubes and suggests aggregates to improve cube performance.
The guide explains the aggregation advisor workflow and its results, how to run a report in dynamic query mode, how to open and explore query log files, and how to work with DQM server logs. It closes with the accessibility features of the tool and troubleshooting information for cases where query log files cannot be accessed. This manual is written in French.
| Product version | 11.0.0 |
|---|---|
| Tool type | Query visualization tool |
| Included tool | Aggregation advisor |
| Copyright | IBM Corp. 2012, 2018 |
It is a query visualization tool that lets you visualize and troubleshoot query logs when dynamic query reports run in IBM Cognos Analytics.
It is written to help report administrators analyze reports and find performance bottlenecks in dynamic query reports, and modelers and administrators can use the aggregation advisor to tune dynamic cubes.
It analyzes the performance and structure of dynamic cubes and provides suggestions for creating aggregates to improve cube performance.
They are stored on the IBM Cognos Analytics server rather than on the workstation running Cognos Dynamic Query Analyzer.