Oracle Business Intelligence Spreadsheet Add-In Available for Download


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: 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

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.


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

About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.


  1. Looks interesting…if you are wroking with Oracle Applications General ledger, then it
    is worth looking at the GL Wand an excel add-in designed specifically for Oracle’s General
    Ledger data. from