Oracle Developer

A number of times I’ve worked on projects where the client is using Oracle Business Intelligence Standard Edition One (OBISE1) but have not had the time or resources to install development and production versions of the application. Thus, other than developing on the production OBISE1 installation I’ve had to develop on my own application, which happens to be OBIEE.

Oracle basically sellls the two versions as one being the entry level version (OBISE1) and the second being the ‘all dancing’ enterprise version (OBIEE). Theoretically they are the same except that OBISE1 hasn’t all the functionality as OBIEE. A user can very happily start with OBISE1 and when the time comes that they need more functionality or need to upgrade their license for more users then they can seemlessly switch to the enterprise edition, OBIEE.

Logically it would make sense that the two versions are the same, except that OBISE1 has some of the functionality disabled. Logic doesn’t always work in business and it turns out that they are not the same. In fact, they are different versions of thee same tool, OBISE1 being an older version than OBIEE. And it is this fact that makes developing in OBIEE and moving the rpd repositiory to OBISE1 interesting.
(more…)

With the correct heirarchy setup in the Business Model and Mapping area an Answers report will drill down to each successive level. Each level logically being a child of the previous level. However, what happens if we’d like to drill down to data that isn’t part of a heirarchy but is logically child data? In that case we need to use guided navigation to obtain our results.

In this tutorial we will produce a report which details the total amount sold throughout the world in each city of each country. We then want to drill down into the city to find a detailed breakdown of all the products which were sold in that city.

To start we need to produce the 2 reports we want. After that we can then add the guided navigation to enable us to drill down into the detailed report. (more…)

As well as calling any of the Oracle predefined functions you can also create and use your own user defined functions in OBI Answers.

For this example we will create a function that formats a customer’s name and use this function in a report.

Step 1

First we will create a simple report. (more…)

There are a lot of good tutorials out there on Oracle Business Intelligence (formerly Siebel Analytics) Standard Edition (OBISE1) and Enterprise Edition (OBIEE). So, I really do not want to reinvent the wheel. What I have found is that it is the simple things that can sometimes be confusing. The sort of things that a detailed tutorial will assume you know, or ones that you do know, it’s just slipped your mind.
(more…)