Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
This section explains how to export worksheet data from Discoverer to Microsoft Excel Web Query format.
Note: Web Query for Microsoft Excel (*.iqy) format is not available in a Single Sign-On environment. Contact the Discoverer manager or Oracle administrator for more information.
Microsoft Excel Web Query is an external data format in Microsoft Excel that enables you to include dynamic data from an Internet or Intranet URL (e.g. a Discoverer worksheet) in a Microsoft Excel worksheet. For example, you might want to create a Microsoft Excel worksheet that contains a Discoverer sales report for a range of dates that you specify when you open the worksheet in Microsoft Excel. The Microsoft Excel worksheet stores the query used to obtain the Discoverer data, so that the data can be refreshed automatically.
Discoverer enables you to export Discoverer data to Microsoft Excel Web Query format by selecting Web Query for Microsoft Excel 2000+ (*.iqy) from the list of export types. End users can then access dynamic Discoverer worksheets in Microsoft Excel. You can export data to Microsoft Excel Web Query format from both Discoverer Plus Relational and Discoverer Viewer.
Notes
To access Discoverer reports exported to Microsoft Excel Web Query format, Microsoft Excel end users require Microsoft Excel 2000 (or later) and Microsoft Internet Explorer 5.5 (or later).
You can only export numeric and textual data into Microsoft Excel Web Query format. You cannot export Discoverer graphs into Microsoft Excel Web Query format.
Once you have imported a Discoverer report to Microsoft Excel, refresh the sheet in Excel when you want to display up-to-date data. Please refer to Microsoft Excel documentation for more information about how to refresh data in Microsoft Excel.
Microsoft Excel end users are always prompted for a database password or Oracle Applications password.
If you export data from Discoverer when connecting using a private connection or temporary connection to Microsoft Excel Web Query format, you can specify that you want Microsoft Excel end users to be prompted to enter login details, which include:
database user name
database name
Oracle Applications user name (if in an Oracle Applications environment)
Oracle Applications Responsibility (if in an Applications environment)
Oracle Applications Security Group (if in an Oracle Applications environment)
When you export data from Discoverer Plus Relational or Discoverer Viewer to Microsoft Excel Web Query format using a public connection, you do not get the prompt Connection Information? in the Export Wizard (i.e. on the "Export Wizard dialog: Format and Name page"). Excel end users accessing the Excel sheet will simply be prompted for a database password. Therefore, you must supply a database password to Excel end users when you export Discoverer worksheet data to Web Query format using a public connection, to enable them to access the Discoverer worksheet data.
If you export Discoverer data in Oracle Applications Suite Secure Invocation mode (e.g. from an Oracle Applications personal home page within Oracle Business Intelligence System or Embedded Data Warehouse), the Discoverer query stored in the Excel sheet runs in 'standalone' Oracle Applications mode.