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.