Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

19 Exporting data to other applications

This chapter explains how to export worksheet data and graphs in Discoverer Plus Relational, and contains the following topics:

19.1 About exporting Discoverer data to other applications

You can share your worksheets and graphs with other people by exporting the worksheets to popular application formats (for example, Oracle Reports, Microsoft Excel). For example, you might want to:

You can use Discoverer's Export Wizard to export worksheets and graphs in other formats (for more information, see "How to export Discoverer data"). You can also use buttons on the toolbar to export Discoverer data to Microsoft Excel and HTML formats.

When you export a worksheet, you export the data in the worksheet. Depending on the export format you choose, the exported worksheet might also contain its formatting and layout information. In some application formats, the exported worksheet might also contain Discoverer items. For example, if you export to Oracle Reports you export Discoverer calculations and totals. In other words, you can view the exported data in another application, but you cannot apply all Discoverer features to the data in that application.

In Discoverer, you export data for items currently displayed on the worksheet. To export data that is not currently displayed, ensure that you display the items on the worksheet before you start. If you do not want to export data displayed on the worksheet, ensure that you remove the items from the worksheet before you start.

You can export:


19.2 About exporting worksheets to Oracle Reports

You can export worksheet data from Discoverer to Oracle Reports. You can then use Oracle Report's reporting features (for example, multi-component reports, break charts) to further enhance the worksheet data.

When you export worksheets to Oracle Reports, the export file includes the Discoverer query definition used to create the worksheets. When Oracle Reports opens the export file, this query is executed and the report is refreshed with up-to-date data. In other words, you do not have to repeat the export from Discoverer to get up-to-date data in Oracle Reports.

When you export Discoverer worksheets to Oracle Reports, worksheet data is exported in the Extensible Markup Language (XML) format used by Oracle Reports. During export, Discoverer populates Oracle Report's data model, reports layout, and previewer.

Exported worksheet data is displayed in Oracle Reports. When you open an exported Discoverer worksheet in Oracle Reports, you have everything that you require to continue to work on the report definition on a standalone system.

The table below shows Discoverer features that are supported by Oracle Reports:

Discoverer feature How it works in Oracle Reports
calculations Oracle Reports preserves worksheet calculations.
format styles and symbols Oracle Reports preserves the following worksheet formatting:
  • font

  • alignment

  • text color

  • background color

  • NULL value substitution

  • currency symbols

  • format masks

  • text style (for example, upper/lowercase, capitalization)

formatting Oracle Reports users can add, edit, and delete format and exception formats defined on items.
layout Oracle Reports users can move items around.
NLS Oracle Reports must be started using the NLS settings used in the original Discoverer worksheet.
parameters Oracle Reports users can continue to use worksheet parameters.
SQL Discoverer exports an easy-to-read SQL statement for each report that you can edit in Oracle Reports.

For example, you can edit SQL for calculations and totals.

titles Oracle Reports preserves worksheet titles.
totals Oracle Reports preserves worksheet totals, which are mapped to Oracle Reports summaries.
worksheet items Oracle Reports users can edit the conditions and parameters used in the worksheet.


19.3 About exporting worksheets to Microsoft Excel

You can export worksheet data from Discoverer to Microsoft Excel. You can also export formats and formulas to Microsoft Excel. When you export to Excel, your worksheet fonts, colors, and styles are preserved in Excel.

Note: For more information about exporting worksheet data to Microsoft Excel Web Query format, see "About exporting worksheets to Microsoft Excel".

The table below shows how different versions of Microsoft Excel impose limits on the maximum number of Discoverer rows allowed in an Excel sheet.

Microsoft Excel version Maximum number of Discoverer rows per Excel sheet How Microsoft Excel handles additional rows
Excel 97 65,536 Any additional rows are placed on additional Excel sheets.
Excel 2000 65,536 Any additional rows are placed on additional Excel sheets.


19.4 About exporting worksheets to Microsoft Excel Web Query format

This se