|Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)
Part Number B40105-02
|PDF · Mobi · ePub|
This chapter explains how to export worksheet data and graphs in Discoverer Plus Relational, and contains the following topics:
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:
e-mail a Discoverer worksheet in HTML format to your manager
use the power of Oracle Reports to customize a Discoverer worksheet
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:
all worksheets in a workbook
graphs associated with worksheets (except when exporting to Oracle Reports)
When an export is complete, Discoverer's "Export Log dialog" displays a list of files created during the export, and enables you to automatically open the first export file.
Your computer platform and default settings determine which application is used to open files of different types.
Some Internet browsers impose a limitation on the number of columns that can be displayed. If you export a worksheet with a large number of columns (for example, over 1000) in HTML format, the Internet browser might not be able to display all columns. For example, Microsoft Internet Explorer only displays up to 1000 columns.
You can also create a PDF (Portable Document Format) file by printing to Portable Document Format (for more information, see "How to print Discoverer workbooks and worksheets to PDF files").
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:
|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.|
When you export worksheet data to Oracle Reports, note the following limitations:
Oracle Reports does not support Discoverer graphs
Oracle Reports does not support Discoverer percentages
If errors occur during the export process, Discoverer generates warning messages. You can use these messages to diagnose discrepancies between a report in Discoverer and the same report in Oracle Reports.
To automatically open a file you export in Oracle Reports, files with a filename suffix of '.xml' must be associated with Oracle Reports. Because many different applications can open '.xml' files, you might have to change an existing association between '.xml' files and another application.
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.|
When you export a worksheet and a graph to Excel format, the worksheet data is displayed in the spreadsheet. The graph file (a PNG format file by default) is placed in the default drive location, and can be inserted manually into the spreadsheet using Excel's Insert | Picture | From File option.
Contact the Discoverer manager to find out whether Discoverer is configured to export to Microsoft Excel 97.
When export worksheets to Microsoft Excel, you must export to a version of Microsoft Excel in the same local language as Discoverer Plus Relational.