MicroStrategy ONE

Database instance selection for Query Builder

A database instance is an object that MicroStrategy uses to connect to a data source such as a relational database. You must create a database instance for your data source before MicroStrategy products can access the information stored in it.

To make a database instance available for Query Builder

  1. In MicroStrategy Developer, right-click a project and select Project Configuration. The Project Configuration dialog box opens.

  2. Expand Database instances and select SQL Data warehouses.

  3. Select the check boxes for the database instances that should be available for use with Query Builder.

For any Query Builder report that you create, you must indicate which data source the SQL queries will run against. You select the database instance in the Database Instance drop-down list in the Query Builder Editor. After selecting a database instance, you can begin creating a Query Builder report.

All database instances that have been defined for Query Builder reports are loaded automatically into the Database Instances drop-down list. Only relational and operational database instances are displayed. Relational and operational database instances in MicroStrategy connect to any data source other than MDX cube sources such as SAP BW, Microsoft Analysis Services, Hyperion Essbase, or IBM Cognos TM1. Examples of relational and operational data sources are relational databases, excel files, and text files.

If there are no database instances listed, you do not have access to any of the database instances. In this case, the following message appears, "You do not have access to any database instance. Please contact your administrator."

To select a database instance in a Query Builder report

  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.

    While database instances commonly point to a relational database, you can also create Freeform SQL reports from database instances connecting to text files or Excel files.

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