Using SQL View to inspect SELECT statements
A developer's best friend: SQL View is a way to look at the statements that MicroStrategy sends to the RDBMS. This window is probably the most useful debugging tool that we have at our disposal.
During the development phase or for customer support, from this view it is easier to troubleshoot a report that takes forever, returns no rows, or just fails with no evident reason. But it is even more useful to understand how the SQL generator interprets the objects that we build day after day. I call it my personal peep show.
Getting ready
You need to have completed the previous recipes and exercises to continue.
How to do it...
If not already there, go to My Personal Objects | My Reports folder.
Double-click on 03 FactInternetSales row Count to run the report.
When the result appears select the View | SQL View menu.
Look at the window, there is a lot of useful information here (number of rows/columns returned, query execution time, and so on). And, near the...
