IBM Cognos Dynamic Query Analyzer Version 11.0.0 User Guide

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 User Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
29
File format
PDF
File size
401 KB
Published
29 November, 2023
Updated
29 November, 2023
MD5 checksum
2A3726DE5A0E5D593574E554770E205B

About this manual

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.

What's inside

  • Introduction
  • What's new
  • Getting started with Cognos Dynamic Query Analyzer
  • Optimize dynamic cube performance with Aggregate Advisor
  • Analyzing query log files
  • DQM server logs
  • Accessibility features in Cognos Dynamic Query Analyzer
  • Troubleshooting Cognos Dynamic Query Analyzer

Specifications

Version11.0.0
Tool typeQuery visualization tool
Included toolAggregate Advisor

Frequently asked questions

What is Cognos Dynamic Query Analyzer used for?

It is a query visualization tool for visualizing and troubleshooting query logs generated when dynamic query reports run in IBM Cognos Analytics.

What does Aggregate Advisor do?

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

How do I view query log files?

Query log files are no longer shown by default; click Window, Analyze logs to view them.

Who is this guide intended for?

It is intended to help report administrators analyze reports and find performance bottlenecks in dynamic query reports; modelers and administrators can use Aggregate Advisor.

Download PDF (401 KB)

More IBM Manuals


View all IBM manuals →