Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Basics of Working with Requests in Oracle BI Answers >

Integrating an Oracle BI Request with Microsoft Excel's Internet Query Feature

Integrating an Oracle BI Answers data request with Excel's Internet Query (IQY) feature allows you to run the request from within Excel. This feature can be useful for printing and distributing reports.

When the IQY file is opened in Excel, you are prompted to enter your Oracle BI user ID and password. (You must have a nonblank password.) Then, the results of the saved request are retrieved and placed in an Excel spreadsheet. You can save the Excel spreadsheet so that the data can be refreshed directly from within Excel.

NOTE:  You may not be able to download results into an Excel spreadsheet if your organization is using certain security features. For more information, contact your Oracle BI administrator.

By default, Excel prompts you to enter your user ID and password each time the query is refreshed. Alternatively, you can save your user ID and password within the spreadsheet. Consult your Excel documentation for details.

NOTE:  You can integrate requests into Excel's IQY feature only with results that appear in one or more table or pivot table views. Other view types are not supported.

To integrate an Oracle BI request with Excel's IQY feature

1. Save a request with one or more table or pivot table views.
2. At the Advanced tab in Oracle BI Answers, click the link to generate and download a Web Query file.
3. Save the file to the desired location.

   After opening the file in Excel, you can modify it, specify additional formatting, enhance it with charts, and so on. For information, see your Excel documentation.