Working with Queries in SQL
For each query in a report, you can work with
the SQL that is executed when you run a report.
You can
- view the SQL for an entire report or a query
- build a report using your own SQL
- convert a report to use SQL directly
- edit the SQL
When working with a relational data source, the SQL that is produced by IBM Cognos Analytics - Reporting depends on the report output selected.
Note: MDX is not available with relational or DMR data
sources.