Export a Visualization

You can export visualizations in a variety of formats to view, store, and share with others.

You can export data from a visualization that's embedded in another application or web page. See About Embedding Oracle Analytics Content into Applications and Web Pages.

You can specify the following output options when you export a visualization:

  • For Powerpoint (pptx), PDF, and Image (png) — Specify the file name, paper size, and orientation.

    When you share any of these visual formats, the visualization is re-rendered based on the size and orientation you select. So if you're sharing a table, then your output file might not contain all of the table's rows and columns displayed in your visualization.

    When you export to PDF format, you can optionally specify a password to protect the PDF file.

  • For Data (csv) — Specify the output file name. This option only includes the data used in the workbook. The output file uses the data delimiter for your computer's locale. For example, if your locale is set to Brazil, then the delimiter for numeric decimals is a comma instead of a period, which is used when your locale is set to United States.
  • For Excel (xlsx) — Specify the output file name for table and pivot table data. Oracle Analytics exports data and time values exactly as they appear in the data source. Oracle Analytics applies no time zone conversions during export, for example, time zone system settings or the user's time zone settings.
  • For Package (dva) — Specify whether to include workbook data, connection credentials, and access permissions. To export the workbook as a self-contained file with data, connection details, and permissions, choose File from the export options, then select Package (dva) in the Format field. To password-protect the file, specify a password in the Protect Password fields.
  1. On your home page, hover over a workbook containing the visualization that you want to export, click Actions, and select Open.
  2. Click Edit to display the workbook for editing.
  3. On the Visualize canvas, hover over the visualization that you want to export, and click Export Share icon on the visualization toolbar.
  4. Select a format from the drop-down list.
  5. Use the File dialog to specify the output options.
  6. Click Save.

Tips on Exporting Data in CSV Format

Here're some tips on getting the best results when exporting a visualization in CSV format.

Limit the amount of data to avoid export issues:

If your data exceeds the maximum number of rows allowed in an export (which includes displayed rows and hidden rows), apply filters to data in a canvas or visualization to reduce the amount of data being exported. For example, you might apply a filter to a visualiztion to display only data for the months January, February, and March to reduce the amount of data.

If export exceeds five minutes you might see errors such as "connection lost contact", "end-of-file on communication channel", "0 - error", or "error 500".

The size of your Oracle Analytics Cloud instance determines the maximum number of rows you can export to CSV and Excel. For more information, see the "Limits Exporting Data (Data Visualization Workbooks)" section in What Sizing Options are Available to You?