MicroStrategy ONE

Query Builder reports for Excel - Step 4: Creating a Query Builder report with Excel data in MicroStrategy

You must complete Step 1: Preparing the Excel File, Step 2: Setting up the data source (ODBC), and Step 3: Creating a database instance for the Excel file before performing the following steps.

  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 the database instance you created during the previous procedure Step3: Creating a database instance for the Excel file.

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

  4. You can now use the tables created by the Excel file to build your Query Builder report using the methods described in the topicSteps to create a Query Builder report.