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.