The following client-based user interface is available for use with IBM® Cognos® Dynamic Cubes.
IBM Dynamic Query Analyzer
IBM Cognos Dynamic Query Analyzer is an Eclipse-based client user interface that provides graphical representations for the query logs produced by dynamic query mode queries. In addition, Cognos Dynamic Query Analyzer includes the Dynamic Cubes Aggregate Advisor, a tool that analyzes dynamic cubes and recommends cube aggregation, based on available cube definitions and optional query load, to improve query performance.
Aggregate Advisor can also analyze previously run IBM Cognos Analytics reports and suggest aggregates that correspond directly to these reports. For more information, see the IBM Cognos Dynamic Query Analyzer User Guide.