Exporting the Oracle Analytics Results

Oracle Analytics provides options for exporting results into different formats. This is done using the Export link available in each report and dashboard. The different export options are listed as follows:

  • Adobe PDF
  • Microsoft Excel 2003+
  • Microsoft Powerpoint (Powerpoint 2003, Powerpoint 2007+)
  • WebArchive (mht)
  • Data (CSV Format, Tab delimited format, and XML)

The following steps assume that you are already on a result page:

  • Exporting into a PDF

    The result can be exported in PDF format with the following steps:

    1. Click Export.
    2. Select the PDF option.
    3. The File Download dialog opens. Click Open or Save in the File Download dialog.
    4. Based on the user action, the result would either open in PDF format (if Adobe Reader is available in the machine) or will proceed with the Save.
  • Exporting to Microsoft Excel 2003+The result can be stored in Excel format with the following steps:
    1. Click Export.
    2. Select the Excel 2003+ option.
    3. The File Download dialog opens. Click Open or Save in the File Download dialog.
    4. Based on the user action, the result would either open as an Excel sheet (if Microsoft Excel is available in the machine) or will proceed with the Save.
  • Exporting to Microsoft Powerpoint

    The result can be stored in Powerpoint slides with this option. This option also has two sub-options: Powerpoint 2003 and Powerpoint 2007+.

    Execute the following steps:

    1. Click Export.
    2. Select the Powerpoint option.
    3. Select from one of the secondary options: Powerpoint 2003 or Powerpoint 2007+.
    4. The File Download dialog opens. Click Open or Save in the File Download dialog.
    5. Based on the user action, the result would either open in Powerpoint (if Microsoft Powerpoint is available in the machine) or will proceed with the Save.

  • Exporting to Web Archive (mht)

    Execute the following steps:

    1. Click Export.
    2. Select the WebArchive (mht) option.
    3. The File Download dialog opens. Click Open or Save in the File Download dialog.
    4. Based on the user action, the result would either open as an MHT file or will proceed with the Save.
  • Exporting the results in Data Format

    The results can be exported in CSV format, tab delimited format, and XML format.

    Execute the following steps:

    1. Click Export.
    2. Select the Data option.
    3. Select the CSV sub-option.
    4. The File Download dialog opens. Click Open or Save in the File Download dialog.
    5. Based on the user action, the result would either open as a CSV formatted file with the application for which CSV format is configured or will proceed with the Save.

Add to Briefing Book

This section explains briefing books and the steps to add content to briefing books.

About Briefing Books

A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analysis, and Oracle Analytics Publisher reports. If your organization is licensed for Oracle Analytics Briefing Books, you can work with briefing books. A briefing book allows you to perform the following tasks:

  • Add the content of dashboard pages (including pages that contain Oracle Analytics Publisher reports) or individual analysis to new or existing briefing books.
  • Edit briefing books to reorder content, delete content, and change the content type, navigation link properties, and content description.
  • Download briefing books in PDF or MHTML format for printing and viewing.
  • Add a list of briefing books to a dashboard page.
  • Update, schedule, and deliver briefing books using agents, if your organization is licensed to Oracle Analytics Delivers.

Adding Content to Briefing Books

Execute the following steps to add content to a briefing book:

  1. Navigate to the page to add or to the page that contains the analysis to be added.
  2. Perform one of the following actions:

    To add the contents of the dashboard page to a briefing book, click the Page Options toolbar button on the Dashboard page and select Add To Briefing Book.

    To add the results of an individual analysis to a briefing book, locate the analysis on the dashboard and click the Add to Briefing Book link.

  3. The Save Briefing Book Content dialog is displayed.
  4. Click Browse to display the Save As dialog.
  5. In the Save As dialog:

    To save the contents to a new briefing book, specify the location in which to save the briefing book in the Save In field. Enter a name for the briefing book in the Name field. You can also enter a description in the Description field (optional), and click OK.

    To save the contents to an existing briefing book, select the briefing book and click OK.

  6. In the Save Briefing Book Content dialog, complete the remaining fields as appropriate.
  7. Click OK.
  8. The content is now added to the briefing book.

For more information about the briefing book, please refer to the Oracle Analytics Server Administration and User Guide or Help files.