Edit the SQL or MDX

You can edit the SQL or MDX for a query that has been created as an SQL or MDX query or that has been converted to SQL.

Procedure

  1. Click the Queries icon Queries icon, expand the query, and click the SQL or MDX item under the query.
  2. In the work area, double-click the SQL or MDX item.
  3. Make changes in the text box.

    If you are working with MDX, you must be aware of the MDX syntax that IBM Cognos Analytics - Reporting supports.

  4. Click Validate to check for errors.