MicroStrategy ONE

Building reports with Query Builder

Overview

Query Builder provides an easy-to-use graphical user interface that allows you to quickly access your data without having to write any SQL. Queries can be run against imported database tables. This functionality allows you to begin reporting and analysis with MicroStrategy without performing the project creation step of modeling attribute and fact schemas, which is necessary for the ROLAP Engine. You can even import tables into a project's Warehouse Catalog using the Query Builder feature.

Query Builder allows you more control over the SQL generated against your database systems, without the need for extensive knowledge on how to create SQL statements. However, basic knowledge of how SQL statements use tables, columns, and joins to build queries is essential.

In addition to simplifying the process of data access, Query Builder provides the majority of MicroStrategy's wealth of reporting and analysis capabilities.

For information on how to create Query Builder reports, click any of the following links:

For a list of links to topics on Query Builder tasks, see Query Builder procedures.