KB10522: How to generate and retrieve the SQL generated when submitting a report for execution through MicroStrategy Web 9.x and 10.x without executing the SQL against the warehouse database

Execute the following steps to generate and retrieve the SQL generated when submitting a report for execution through Strategy Web 8.1.x without executing the SQL against the warehouse database:

1. Back up the file named pageConfig.xml in the <Installation Directory>\Web ASPx\WEB-INF\xml directory.
2. Locate the following node within the Report Execution page. Refer to the Strategy SDK documentation (Strategy Developer Library) if unsure about the Report Execution page or the roles of pageConfig.xml ):
   <web-bean bean-type="md" name="rb" persist-mode="2" sys-bean="ReportBean">
   
3. Within the web-bean named "rb," locate the <request-properties> node. Add the following properties:
   <property name="resultFlags" source="const" type="int" value="2052" /> <property name="executionFlags" source="const" type="int" value="131072" />
   
4. Save the pageConfig.xml file.
5. Restart Internet Information Services (IIS) for the changes to take effect.
6. Execute a report from Strategy Web. Notice the empty grid and the following message:
   No data returned for this view because this report has no template objects. Please add objects to the template.
   
7. In the Menu labeled "Report," select Report Details. A number of report details are available, including the SQL for the report.

NOTE:
For a complete explanation of beans and properties, review the Strategy Developer Library, part of the Strategy SDK.
 
Customization Warning:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.