Exporting Data to Microsoft Excel or CSV file

Exporting Data to Microsoft Excel or CSV file

From the Analyzer, you can export the data in a pivot table to Microsoft Excel or to a CSV file by selecting the Export current results button in the Pivot Builder area. On a dashboard, you can also export data to Microsoft Excel from a pivot table widget, but not from other types of widgets. To do so, select the Export to Excel button in the widget.

In the Analyzer, when you export data to CSV by selecting the CSV option from the drop-down menu, the system generates a file that includes the contents of the pivot table, including the column and row labels. The cell values for a given row are separated by comma characters (,), and rows are separated by line breaks. When you select the CSV with Heading option from the drop-down menu, the file includes the same contents as a file exported using the CSV option, with an additional line at the beginning. This line is a heading that identifies the data:

• If the data is derived from a saved pivot table, the heading contains the relative path to the pivot table and the pivot table’s name (for example: "Patient Pivots/Avg Score by Age")

• If the data is not derived from a saved pivot table, the heading provides the name of the source cube or subject area

When you export data to Microsoft Excel, the system generates an Excel file that contains all the data currently displayed in the widget. The file has the name %DeepSee.UI.MDXExcel.zen.xls, %DeepSee.UI.MDXExcel.zen-1.xls, or similar. Your browser then does one of the following, depending on your operating system, the configured file types on your machine, your browser, and your browser settings:

• Opens the file with Excel (or other selected program).

  You specify the program to use by setting a browser option. For example, on Firefox, you use Tools > Options > Applications. This option also enables you to specify whether the browser should open the file with this program or prompt you to save it to the hard drive.

  Note:

  The exported file, while created with an .xls extension, is formatted as an HTML spreadsheet. Excel will prompt you with a warning about the format and extension not matching, but this does not indicate an unusable or unsafe file. When prompted to open the file anyway, click Yes.

• Prompts you to open the file with Excel (or other selected program, as described in the previous bullet).

• Opens this file within the current browser window.

  This is the default behavior for Windows operating systems earlier than Windows Vista. You can change this behavior on the Edit File Type dialog box (which you access via My Computer > Tools > Folder Options or My Computer > View > Options, depending on the operating system version).

  This option is not available on Windows Vista and later Windows operating systems.

• Prompts you to save the file to the hard drive.

• Automatically saves the file to the hard drive.

Exporting to Excel, does not support exporting more than 250000 rows. Also, if the cube is based on a data connector that uses an external table, there is a limit of 1000 rows in the listing.