Business Intelligence OLAP Event (Oracle, The Netherlands) 13422386 1019544571447648 7687716130941590224 o1

Business Intelligence OLAP Event (Oracle, The Netherlands)

The event took place on thursday the 28th of october. During four presentations Oracle presented Oracle OLAP in the data warehouse, the OLAP architecture, Oracle products (like OWB and discoverer for OLAP), and more recent products/add-ins like Oracle Portal, BI Beans and the Excel add-in.

The event was well attended and took off with a presentation about Oracle OLAP in the data warehouse. The presentation showed on a high level the possibilities with Oracle OLAP in the data warehouse. In particular the presentations about integrating the data warehouse in Oracle Portal (very briefly described though), the BI Beans add-in for JDeveloper and the Excel add-in for, yes, Microsoft Excel was quite interesting!

From the ‘hackers’ event I choose to have a better look at the BI Beans add-in for JDeveloper and the Excel add-in. The BI Beans add-in for JDeveloper (10g) can be downloaded from the Oracle web-site (BI Beans download page). The installation manual can be downloaded from the Oracle web site (installation manual) also. Unfortunately, the Excel add-in comes not with the Oracle 10g enterprise edition but with Oracle OLAP, which needs to be purchased separately.

I will describe the BI Beans functionality as well as the excel add-in shortly. Comments of other colleagues on the event are written down below and perhaps a couple of background documents will become available later.

BI Beans
With BI Beans, Oracle provides functionality within JDeveloper to present data from the data warehouse via a web browser. After creating pages with the Business Intelligence Beans, the project can be deployed. This means that data from the data warehouse can be retrieved via a web browser everywhere around the globe. But of course this type of (delicate) data is more suitable for an intranet application.

With BI Beans you can create tables in where the user is able to down and up-drill or changes the line of approach, although you have web page limitations.

For instance, a user is looking at data in where the total of sales per country is shown. The user then can up-drill by choosing a country and see the total sales per product. By changing the line of approach, the user can choose a product and see the total sales of that product per country, etc.

You can create graphs in where the user is able to down and up-drill by easily click the graph! Changing the line of approach is possible here also, but the original layout of the graph remains the same.

Excel add-in
The excel add-in gives a new menu option in Microsoft Excel with the name OracleOLAP. To make use of the add-in, you have to create a connection with the database. To create a connection with the database you make use of the same wizard as the wizard used to create a connection with the database in JDeveloper. Then, a query wizard, which again is the same as the one used in JDeveloper BI Beans, guides you through the necessary steps. Data is retrieved from the database and presented in Excel (without formulas). You are able to up and down-drill within Excel. By up and or down-drilling, a connection with the database is required because not all the data is present whenever the query is executed the first time. The functionality of Excel can be used, which is an advantage but at the same time a disadvantage. For instance, you can summarize a column in excel which gives a certain value. When you up and or down-drill, the value can change…

2 Comments

  1. Henri Clemens November 5, 2004
  2. Cindy Barendregt & Jolanda van Gilst November 5, 2004