Download report data dialog

To download a report's data to your computer, first select a format and then click OK.

The following download formats are provided:

• CSV - Comma-delimited or semicolon-delimited ASCII format. A Windows Save As dialog box appears. Choose a file name and location, and then click Save.
• XML - XML Spreadsheet for Excel. Reports saved in this format resemble the original Perspective report in their colors and formatting. Choose a Data Format and click OK. For more information, see Data Format (below).

  This option creates an XML file for use with MS Excel 2003 or later. Note that files saved in this format cannot be opened by earlier versions of Excel.

  Note: Not all Perspective sites allow downloading. In that case the download button will not be present on the toolbar.

  Note: To preserve server resources, there are site limits for the number of data cells that can be downloaded to each format. The download limit is set by the Perspective site administrator. If your report exceeds the limit, you will have to remove some selections to reduce its size.

  Note: When downloading to XML format, currency and decimals in the spreadsheet will be formatted according to the computer on which Excel is being run. You should set your computer's regional settings to be the same as the language you use in Perspective. For example, if the Perspective language settings show français (France), which formats currency values with Euros, but you download on a computer whose regional settings are set to English (United States), you will see English currency formatting (dollar signs and a period for the decimal places) when you open the Excel spreadsheet.

Data Format

One worksheet per report

• If chosen, a Perspective report generates one Excel worksheet per chosen format (numeric, text, or both), which shows all the report's dimensions.

One worksheet per 2-dimensional data slice

• If chosen, a data slice in a Perspective report generates one Excel worksheet per chosen format (numeric, text, or both). Each worksheet shows one slice only.

List Format

• If selected, a Perspective report generates one numeric Excel worksheet that contains one record for each combination of non-measure dimensions. The data columns contain cell values - one per measure if a measures dimension is present, or else one per cell.

Sparse List Format

• If selected, empty rows and columns (those that contain no data values) will be eliminated from the Excel worksheet.