Editing a Query Builder report

If you need to modify the data that is returned by a Query Builder report, you must edit the query and objects mapped for the Query Builder report. These modifications can be done from the Query Builder Editor. Refer to the procedure below to edit a Query Builder report.

Prerequisites

• The procedure below assumes you have already created a Query Builder report.

• You must have the Define Query Builder report and Create schema objects privileges to access to the Query Builder Editor.

To edit a Query Builder report

1. In MicroStrategy Developer, locate the Query Builder report, right-click the report, and choose Edit. The report is displayed in Design view in Report Editor.

   To modify the SQL query or column mappings in any Query Builder report, you must display the report in Design View first.

2. From the Data menu, select Query Builder Definition. The Query Builder Editor opens.

3. Modify the SQL query or the column mappings as needed.

4. Click OK to exit the Query Builder Editor and return to the Report Editor.

5. Modify the report as needed.

6. Save the report and run the report as needed.