When you import data from a file, such as an Excel spreadsheet, to use to create reports, documents, and analyses in MicroStrategy Web, you can display a preview of the data on the Preview page. By default, the first few rows of data in the file are displayed.
You can:
View a sample of your data before it is imported
Insert column headers into the data, if the file does not provide them
Select the sheet of data to import, if you are importing the data from an Excel workbook with more than one sheet
Steps to select these options are below. For background information about importing data from a file or database to create reports, documents, and analyses, and for steps, see the Importing Data chapter in the Advanced Reporting Guide.
If the file used to import data is an Excel workbook with more than one sheet of data, select the name of the sheet from which you want to import data from the Sheet Name drop-down list.
By default, Web identifies the first row of data to use as headers for the imported data columns. These column headers are then displayed as the names of the attributes and metrics you define. If the data in the imported file does not provide column headers for the data columns, you can insert and specify the column headers manually by doing the following:
Select the Insert new column headers check box. A default column header is automatically inserted for each data column.
Click on the column header of each data column, and type a name for the header in the field.
Click Next. The Column Mapping page is displayed.
Related topics