SQL view

You can see the SQL used to generate the report. Viewing the SQL provides a good way to troubleshoot and fine-tune the selection of data that is retrieved from your data source and displayed in reports. SQL view also includes various execution statistics for a report, such as the number of rows, number of columns, the time it took to execute, and so on. The following figure displays the SQL view of a report in Developer.

To see the SQL for a report in MicroStrategy Web, from the Tools menu select Report Details Page. The SQL is displayed in the SQL Statement area. Click Show Advanced Details below the SQL Statement area to see execution statistics for the report.