MicroStrategy ONE

Creating Freeform SQL report or Query Builder report with text file data - Step 1: Preparing the text file

This procedure assumes you have an existing text file that is formatted for use as a data source through an ODBC connection.

When you prepare a text file for MicroStrategy use, ensure that:

  • The file is a text file (.txt).

  • A delimiter separates the data in the text file into columns for a database table. The following procedure assumes a comma (,) is used as the delimiter character.

    You can use any standard delimiter characters except for a single quote (') or double quote ("). A comma is the default delimiter character.

  • Column names must appear in the first row of the file and are delimited.

  • The file path that your text file is saved in is used as the data source directory for MicroStrategy reports.

Next step