Query Builder Editor

The Query Builder Editor allows you to define the SQL queries to run against imported database tables. You can define SQL queries with Query Builder using a combination of database tables, columns, and joins.

Prerequisites

Before you can begin creating Query Builder reports with the Query Builder Editor, you must configure a database instance to be available for Query Builder.

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

Accessing the Query Builder Editor

You can access the Query Builder Editor from MicroStrategy Developer or the Report Editor.

Query Builder Editor contents

To get started with the Query Builder Editor, review the information in Overview of Query Builder reports and Query Builder reports versus standard reports. You can also refer to a list of all the Query Builder procedures, and review the available toolbar options.

The list of procedures below follows the general order in how to get started using the Query Builder Editor:

• Configuring and selecting a database instance

• Creating a Query Builder report

• Adding a table

• Creating a join

• Selecting a column

• Creating qualifications in Query Builder

• Inserting a security filter qualification in Query Builder