IBM Cognos Dynamic Query Analyzer 11.0.0 User Guide

The IBM Cognos Dynamic Query Analyzer Version 11.0.0 User Guide describes the features and functions of the product.


IBM Cognos Dynamic Query Analyzer 11.0.0 User Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
French
Pages
33
File format
PDF
File size
1 MB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
703B1CD33ED7E2EE8B53C1A5E7BAA5B9

About this manual

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.

What's inside

  • What's new
  • Introduction to Cognos Dynamic Query Analyzer
  • Optimizing dynamic cube performance with the aggregation advisor
  • Running the aggregation advisor
  • Aggregation advisor results
  • Analyzing query log files
  • Opening query log files
  • Exploring query log files
  • DQM server logs
  • Accessibility features

Specifications

Product version11.0.0
Tool typeQuery visualization tool
Included toolAggregation advisor
CopyrightIBM Corp. 2012, 2018

Frequently asked questions

What is Cognos Dynamic Query Analyzer?

It is a query visualization tool that lets you visualize and troubleshoot query logs when dynamic query reports run in IBM Cognos Analytics.

Who is this guide intended for?

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.

What does the aggregation advisor do?

It analyzes the performance and structure of dynamic cubes and provides suggestions for creating aggregates to improve cube performance.

Where are aggregation advisor results stored?

They are stored on the IBM Cognos Analytics server rather than on the workstation running Cognos Dynamic Query Analyzer.

Download PDF (1 MB)

More IBM Manuals


View all IBM manuals →