Web Intelligence 4.0: View the SQL or MDX script for a query
When you run a query, Web Intelligence retrieves the data by running a script consisting of a series of SQL or MDX statements. SQL statements are used by relational databases, while MDX statements are used by OLAP databases. Web Intelligence allows you to view and edit the SQL generated by a query, and even copy and paste it to another application. You can view MDX queries but you cannot edit them.
In this tutorial, you will view the SQL for a query.