Oracle Business Intelligence Spreadsheet Add-In Available for Download

Lucas Jellema 2

As was announced early in 2004, Oracle has just released the Oracle Business Intelligence Spreadsheet Add-In. This is an add-in for Excel.

OracleBI Spreadsheet Add-In enables end users to display and navigate Oracle OLAP data from within Excel. Users can treat the Oracle OLAP data as regular Excel data. For example, they can create formulas and graphs, which enables them to combine the powerful analytic capabilities of Oracle OLAP with standard Excel functionality. Using a wizard-driven interface, users can select data from Oracle OLAP simply by choosing from a list of values or by creating advanced selections, such as those based on exceptions, top/bottom analysis, or hierarchies. In addition, users can create Oracle OLAP-based calculations using a wizard. The built-in Query Wizard and Calculation Wizard are based on the Oracle Business Intelligence Beans wizards, thus ensuring a consistent interface with other applications that are based on Oracle Business Intelligence Beans.

With this add-in, it becomes much easier to make use of the OLAP functionality in the Oracle 9iR2 and 10g database. Wizard-driven from Excel, end-users with only a little training should be able to perform analysis that otherwise would require the use of custom built applications or the configuration of Analysis tools such as Discoverer.

As of yet I have not done anything with the plugin, so I will reserve both judgement and recommendations. I hope to tell you more in a few weeks.

The homepage of the Oracle BI plugin for Excel: http://www.oracle.com/technology/products/bi/spreadsheet_addin/index.html. View an online demo.
Installation instructions.

The software can be downloaded from OTN through a download link to the standalone Excel plugin available from the homepage : Download OracleBI Spreadsheet Add-In 10g 10.1.2.0.0.

Sample Application: The Common Schema – required for the plugin samples – can be downloaded as part of the overall (59.7 Mb) BI Samples ZipfileDownload Samples.

Resources

BI Scorecard: Excel Integration – Part four in a series of reviews evaluating business intelligence suites one functional area at a time.

2 thoughts on “Oracle Business Intelligence Spreadsheet Add-In Available for Download

Comments are closed.

Next Post

Effective Oracle by Design

Facebook0TwitterLinkedin Title: Effective Oracle by Design – Design and Build High-Performance Oracle Applications Author: Thomas Kyte Published by: Oracle Press ISBN: 0-07-223065-7 Publication Date: 2003 Details: 664 pages, $59.99; www.OraclePressBooks.com I recently read this nice book written by Thomas Kyte. In this book Kyte addresses a lot of different design […]