Creating a Freeform SQL report from text file - Step 4: Creating a Freeform SQL report from text files

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

1. In MicroStrategy Developer, 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 in Step 3, Creating a database instance for the text file.

3. Select Create Freeform SQL report and click OK. The Freeform SQL Editor opens.

   • Column names in the SQL statement have to match the field names in the text file.

   • Case does not matter, as long as the column names are correct.

4. In the Mapping pane (the bottom pane on the right), map the columns in your SQL statement to attributes and metrics that will be used in the MicroStrategy report.

   • When mapping the columns, it is important that you follow the same sequence of the columns as they appear in the SQL statement or the report fails.

   • Ensure the number of mappings is the same as the number of columns in the SQL statement. For example, if your SQL statement lists 10 columns from which to retrieve data, you should map them to exactly 10 objects, including attributes and metrics.

   • For each attribute, you must map a column to the ID form.

5. Perform other tasks as needed. For more information see Creating a Freeform SQL report.

6. Click OK to close the Freeform SQL Editor. The Report Editor opens in Design view by default.

7. From the File menu, click Save or Save As. The Save Report As dialog box opens.
   

   You must save the report before you can run it.

8. Enter a name for the report and click Save.

9. Run the Freeform SQL report.