Freeform SQL reports and Query Builder reports for Excel - Step 3: Creating a database instance for the Excel file

You must complete Step 1: Preparing the Excel File, and Step 2: Setting up the data source (ODBC) before performing the following steps.

1. In MicroStrategy Developer, create a new database instance to point to the DSN for the Excel file, created in Step 2: Setting up the data source (ODBC).

2. To make the database instance available for your Freeform SQL and Query Builder reports, right-click a project and select Project Configuration. The Project Configuration dialog box opens.

3. Expand Database Instances, and select SQL Data Warehouses.

4. From the list of available database instances, select the check box for the Excel file database instance and click OK.

Next step

• Step 4: Creating a Freeform SQL report from Excel files

  • Or

• Step 4: Creating a Query Builder report from Excel files