MicroStrategy ONE

Parse Your Data Dialog

Web assumes that your data is stored in a simple tabular layout by default, with each column in the table containing a separate attribute or metric. You can also import data stored in a cross-tabbed layout, with attributes and metrics stored in both table rows and columns.

Access

  1. Create a blank dashboard or open an existing one.
  2. Choose Add Data > New Data to import data into a new dataset.

    or

    In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. The Preview Dialog opens. Click Add a new table.

    The Data Sources dialog opens.

  1. Select the data you want to import, according to your data source type.
  2. In the top pane, click the drop-down arrow for the table you want to modify and select Parse.

The Parse Data option is not available if you are importing data from a database.

Fields

Tabular: Select to import data from a simple tabular layout. Web uses the first row of data as headers for the imported data columns, by default. These column headers appear as the names of the attributes and metrics that you define.

If the data in the import file does not provide column headers for the data columns, you can add them manually. Select the Insert new column headers checkbox. A default column header is inserted for each data column.

If the first several lines of data are not necessary, you can skip them during import. Enter the number of rows you want to skip in Skip.

If the original data is combined by a specific separator, you can input the delimiter to split them into several columns. Delimiters in quotes are not treated as separators. See How to Import and Parse .csv and .txt Files for more information.

Crosstab: Select to import data from a cross-tabbed layout. A preview of your data appears, with cells of data that contain metric data, attribute data, and metric header names that appear in separate colors. The legend in the top right lists the colors in which each type of data appears.

See Preview Data and Specify Import Options for more information about creating tabular and cross-tabbed layouts.

Related Topics

Import Data

Best Practices for Importing Data from a File