Running a report that uses dynamic query mode

You can run a report using the IBM® Cognos® Analytics web interface, or you can run it using IBM Cognos Dynamic Query Analyzer.

Before you begin

Before running the report, the query execution trace option of Query Service must be enabled. This option can be enabled in either of two ways.
  • Your administrator can enable the query execution trace option in IBM Cognos Administration. This option is enabled for all reports run either through the Cognos Analytics web interface or through Cognos Dynamic Query Analyzer. For more information, see the topic on Query Service administration in the IBM Cognos Analytics Administration and Security Guide.
  • You can enable query execution trace for reports run through Cognos Dynamic Query Analyzer. To enable this option, click Window, Preferences. On the General tab, check query execution trace. If logging is enabled through Cognos Dynamic Query Analyzer, the system administrator does not need to enable it on a server-wide basis.

If you are running reports through Cognos Dynamic Query Analyzer, the versions of Cognos Dynamic Query Analyzer and the Cognos Analytics server must be the same. Otherwise, the report may not run.

Procedure

Run a report that uses dynamic query in one of the following ways.
  • Use any of the methods available through the Cognos Analytics web interface. For more information, see the IBM Cognos Analytics - Reporting User Guide.
  • In Cognos Dynamic Query Analyzer, navigate to the report in the Content Store view. Right-click the report, and click Run Report. You cannot set prompts for a report when you run it using Cognos Dynamic Query Analyzer.

Results

You can now open and analyze the log files in Cognos Dynamic Query Analyzer.