Object Browser pane for Query Builder

The Object Browser is located on the left of the Query Builder Editor interface. The Object Browser, by default, displays all the imported database tables in the selected database instance. Although all folders in the project are displayed, some folders are empty, if they do not contain objects related to Query Builder reports. For example, although you can browse to the Facts folder, nothing is displayed because facts are not used with Query Builder reports.

Folders

Folders that are related to Query Builder reports include the following:

Freeform Objects: This folder is created when the first Freeform SQL report or Query Builder report is created in your system. The folder contains all the new objects created and used in all Freeform SQL and Query Builder reports against all database instances.
Attributes: Located under the Schema folder, the Attributes folder contains all the attributes previously defined in the project. You can use these existing attribute names when mapping the columns in the SQL statement to those to be used in the MicroStrategy environment.
Prompts: Located under the Public Objects folder, the Prompts folder contains the existing prompts in the project that you can use in your Query Builder SQL queries. For details on using prompts in Query Builder, see Prompts in Query Builder reports.

Only value prompts and element list prompts can be used in Query Builder reports.

Warehouse Catalog: This folder is only available when the selected database instance is a relational or operational database, not an MDX cube source such as SAP, Analysis Services, or Hyperion Essbase. For more information on the difference, see Database instance selection for Query Builder. This folder lists all the imported tables and their columns for the selected database instance.
All Available Tables: The All Available Tables feature displays every table for the selected database instance. To run queries on non-imported tables, Query Builder can import tables from the data warehouse into the Warehouse Catalog of your MicroStrategy project. This allows you to import tables with the Query Builder Editor while creating Query Builder reports rather than having to use the Warehouse Catalog tool.

Accessing the All Available Tables feature can be costly in terms of execution time, therefore All Available Tables should be accessed only when it is necessary to import tables for the database instance for your Query Builder report.

You can browse to other folders within the project if you have saved objects, such as prompts, in different folders.

By default, when the Query Builder Editor is opened, the Object Browser displays the Warehouse Catalog folder that contains the imported database tables for the selected database instance.

Options

The options related to Query Builder reports that are available in the Object Browser pane are the following:

Add Table: Right-click a table in the Object Browser pane and select Add Table. The table is added to the Tables and Joins pane (the top pane on the right) and is included in your Query Builder report definition.
Table Structure: Right-click a table in the Object Browser pane and select Table Structure. A Table Structure dialog box for the selected table opens. The dialog box displays the column names and their data types that reside within the selected table.
Double-clicking an attribute form in the Object Browser inserts the attribute into the first empty row or selected row in the Selections pane (the bottom pane on the right).
Double-clicking a table in the Object Browser inserts the table into the Tables and Joins pane (the top pane on the right) and includes the table in your Query Builder report definition.

You can select multiple objects in the Object Browser by using the CTRL or SHIFT keys.