MicroStrategy ONE

Exporting data

You can export reports in a variety of formats, such as HTML, Microsoft Excel, and plain text. A report's designer determines which export formats are available for a report, based on what makes sense for that report. Each format is described in detail below, to help you decide what format suits your purposes:

  • PDF: You can export the report to an Adobe PDF viewer, in .pdf format. After the report is exported, the report content is displayed in an Adobe PDF file.

  • Excel with plain text: You can export the report to Microsoft Excel, in .xls format. After the report is exported, the content of the report is displayed using the default settings in Microsoft Excel. The structure and format of the report as it is displayed in MicroStrategy Web is not retained. For large report results, this export option is recommended over Excel with formatting.

  • CSV file format: You can export the report to a comma-separated values file (CSV). After the report is exported, the report content is displayed in a CSV file as plain text. This format is suitable for Microsoft Access and Lotus 1-2-3. The structure and format of the report as it is displayed in MicroStrategy Web is not retained.

  • Excel with formatting: You can export the report to Microsoft Excel, in .xls format. After the report is exported, the report displays with the same formatting, color, and structure that appears in MicroStrategy Web.

    • Microsoft Excel does not support all colors that browsers do, so some colors may differ after export.
    • If the report is large, it is recommended that you use the Excel with plain text export option.

  • HTML: You can export the report to an HTML editor or browser, in .html format. After the report is exported, the report is displayed in an HTML page. The structure and format of the report as it appears in MicroStrategy Web is retained.

  • Plain text: You can export the report to a text editor, in .txt format. After the report is exported, the content of the report displays in a plain text page. The structure and format of the report as it appears in MicroStrategy Web is not retained. You can choose a comma, tab, semicolon, or space to separate the fields of text.

Before you export, you can adjust several export options that allow you to specify which report details are exported, whether the data should be exported to PDF or another application, and more.

To export a grid report that contains characters in a double-byte language, such as Simplified Chinese or Japanese, to a PDF, your computer should be using that double-byte language (for example, Japanese Windows). If you are using an English environment, to export double-byte characters, a report designer must change the font of the attribute and metric names to the font type that the locale supports. For steps, see Formatting for easier data analysis or the MicroStrategy Help.

To configure export settings in MicroStrategy Web

  1. Open a report.

  2. From the Home menu, select Export, and then select the required output format.

    • You can modify project-wide graph settings in the User Preferences page. For more information, click Help in MicroStrategy Web.
    • You can modify export options in the User Preferences page. For more information, click Help in MicroStrategy Web.

  3. Make any necessary changes to the export options.

To export data in MicroStrategy Web

  1. From the Home menu, select Export, and then select the required output format.
  2. Make any necessary changes to the export settings and click Export.