OBIEE - Microsoft Excel

Obi Edition

About

Articles about Excel with OBIEE.

Download

OBIEE 10g uses MHTML as the formatting code when downloading files to Excel.

Microsoft Excel's Internet Query Feature

Integrating an analysis with Excel's Internet Query (IQY) feature enables you to run the analysis from within Excel. This feature can be useful for printing and distributing analyses. You can integrate analyses into Excel's IQY feature only with results that are displayed in one or more table or pivot table views. Other view types are not supported.

When the IQY file is opened in Excel, you are prompted to enter your Oracle Business Intelligence user ID and password. (You must have a nonblank password.) Then, the results of the saved analysis 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.

Steps:

  • Generate and download a Web Query file with the help of the link available in the Analysis editor: Advanced tab.
  • Open the file in Excel, you can modify it, specify additional formatting, enhance it with graphs, and so on. By default, Excel prompts you to enter your user ID and password each time that the query is refreshed. Alternatively, you can save your user ID and password within the spreadsheet.

Support

Excel Export Issue on Windows Vista Client

Vista prevents applets from creating files in the local file system if the User Account Control (UAC) system is turned on. You can experience this problem if you have the UAC setting enabled on Vista and if you use a component like Discoverer Plus. If you start Discoverer Plus and if you try exporting a worksheet to a specified directory, the exporting succeeds but you cannot see the exported file in the directory. The available workarounds is to disable UAC and set protection mode to OFF. Refer to Bugs 8410655 and 7328867 for additional information.

Documentation / Reference





Discover More
Bi Server Architecture With Client
OBIEE - Data Source (Oracle Analytics Adapter)

Oracle BI Server has an extensible and open connectivity layer with a set of adapters that are responsible for communicating with source data servers. An Oracle Analytics Adapter is a dynamically loaded...
Odbc Data Source
OBIEE - Federated Query with Excel Sheet

OBIEE permit to integrate data from different database sources. One of the most common is an Excel Sheet. To import some measures from Excel, you have to do several actions : Import the data with...
Obiee Narrative Template For Excel
OBIEE - How to create an HTML view (Narrative, Static Text) to get a good Excel formatting ?

When you download an answer to Excel, you have all the chances to get a bad alignment of the cells when you use a view with HTML tag (such as a narrative view of a static text). OBIEE uses MHTMLMHTML...
Choose Data Source
OBIEE - How to retrieve data from BI Server in Excel ?

An how-to which show how to use BI Server as a data source in excel In excel : Menu / Data / Import External Data / New DataBase Query Choose the ODBC Data Source used to connect to the repository...
Moreproducts
OBIEE - Microsoft Office Server and (Add-in|Plug-In)

Oracle Business Intelligence for Microsoft Office includes the Oracle Business Intelligence Office server and the Oracle Business Intelligence Add-in for Microsoft Office client. The client includes...
Obiee Path
OBIEE 10G/11G - The Go URL

The Go URL is a part of the saw Url and is used to : add an answer in your favorites, link an answer to an other answer issue sql pass filters integrate an answers into an external Web site...



Share this page:
Follow us:
Task Runner