MicroStrategy ONE

Accessing the Query Builder Editor

You can access the Query Builder Editor from MicroStrategy Developer as part of creating a Query Builder report or the Report Editor as part of modifying a Query Builder report.

Access to the Query Builder Editor is available only to Developers with the Define Query Builder report privilege and those with the Create schema objects Common Privilege.

From MicroStrategy Developer

  1. From the File menu select New, and then Report. The New Grid dialog box opens.

  2. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Query Builder.

  3. Select Create Query Builder report and click OK. The Query Builder Editor opens.

If the New Grid dialog box does not open when you select Report, you must modify a MicroStrategy Developer setting, as described below:

  1. In MicroStrategy Developer, from the Tools menu select DeveloperPreferences. The MicroStrategy Developer Preferences dialog box opens.
  2. Select the General tab.
  3. On the Show templates for the following objects: pane, select the Report check box.
  4. Click OK to accept the changes and return to MicroStrategy Developer.

From the Report Editor

  1. Right-click a Query Builder report and select Edit. The Report Editor opens.

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