OBIEE - Intelligent or not?

Something annoying about Business Intelligence - OBIEE

Before I give my opinion on the tool, let me give an overview of what exactly i did with OBIEE.

To begin with - We were given a Cloud Airlines Datawarehouse.

We were to perform our analysis on the various facts, dimensions and then try to answer a few questions.

Here is a sample of what the questions were like:

1.    Flight Delay Analysis: Are there any general patterns of flight delays for Cloud Airlines. Do flight delays typically occur from a set of specific departure and arrival cities/airports? In general are there certain times of the year when there are more or less delays? 

   Secondly, Aircraft Utilization Analysis: How well is each aircraft utilized? Is there any variation in aircraft utilization over time?

   Finally, Seat Utilization analysis: How well is Cloud airlines doing in terms of seat utilization across their various arrival and departure cities, airports, and over time? Are there any seasonal and or temporal variations?

Now, as you might imagine, these questions seem to be quite straightforward to think of logically. When you do actually get to the datawarehouse and try to answer these based on the facts, there comes a bit of trouble.

I had the opportunity to work with OBIEE 10 g a few weeks back and my notion that Oracle produces the crappiest of products was strengthened!