Working with Queries in SQL or MDX

For each query in a report, you can work with the SQL or MDX that is executed when you run a report.

Note: MDX is not available with DMR data sources.

View the SQL or MDX for an Entire Report or a Query
View the SQL or MDX to see what is passed to the database when you run a report.
Build a Report Using Your Own SQL or MDX
You can build a report by adding SQL or MDX from an external source, such as another report.
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.
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.
First-Rows Optimization
The SQL produced by IBM Cognos Analytics - Reporting depends on the report format you choose. For example, if you specify HTML format, first-rows optimization is requested. All-rows is requested if you specify PDF.
Supported MDX Syntax
If you are working with MDX, you must be aware of the syntax that IBM Cognos Analytics - Reporting supports. Cognos Analytics - Reporting supports the MDX grammar as specified in Microsoft Data Access Software Developer Kit version 2.8.

Parent topic: Working with Dimensional Queries