Convert a Query to SQL

You can convert a query to SQL to edit it. You may want to do this to improve performance or to use SQL features that are not supported directly by IBM® Cognos® Analytics - Reporting.

Converting a query to SQL is an irreversible process.

Procedure

  1. From the report navigation menu, click Report > Queries.
  2. On the canvas, click a query.
  3. Click the Show properties icon Show properties icon, and in the Properties pane, double-click the Generated SQL property.
  4. Click Convert.
  5. Click Validate to check for errors.
  6. Select the query, and In the Properties pane, set the Processing property to Limited Local.