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. Click the Queries icon Queries icon, and click the query.
  2. Click the Show properties icon Show properties icon, and In the Properties pane, double-click the Generated SQL property.
  3. Click OK and then click Convert.
  4. Click Validate to check for errors.
  5. Select the query, and In the Properties pane, set the Processing property to Limited Local.