Oracle, I and everything in between

August 14, 2010

obiee 11g is out!

Filed under: OBIEE,obiee 11g — Prakash @ 2:06 pm
Tags: ,

Spreading the word, OBIEE 11g is available for download

Not available on edelivery yet.


June 4, 2010

OBIEE 11g.. coming soon

Filed under: OBIEE — Prakash @ 5:30 pm

Its official. OBIEE 11glaunching on July 7

April 7, 2009

Dashboard Design Tips

Filed under: OBIEE — Prakash @ 9:20 pm

This topic has been covered by numerous authors but it still surprises me how many people still do not follow basic dashboard design principles. Here are some of the arguments that I have heard for not designing dashboards properly.

  • Didn’t have enough time
  • I am not a graphic designer
  • As long as the data is there, I don’t care if it’s pretty

Poor dashboard design defeats the purpose of having a dashboard in the first place. Here are few simple rules that I following during any dashboard design/development

  1. Readability: Too much data, vertical/horizontal scrolls,
  2. Context: Reports are meaningless without context
  3. Location, Location, Location: Know where the most important metrics should be presented
  4. Performance: Never put a long running report on the dashboard page

If you are in hurry, you can find some more tips on Panorama’s blog here. But if you are someone who does dashboard/reports/data visualization for living, I highly recommend that that you read works of the two prominent experts in the field.

Avinash Kaushik

Stephen Few

December 3, 2008

How to find a good OBI consultant

Filed under: OBIEE,Personal Branding — Prakash @ 7:22 pm

Oracle market is filled with consultants claiming to be OBI experts. I have been on a number of projects where bad consultants spend a lot of client money and more have to be spent to fix all the bugs left behind.

As a consultant, here is my recommendation for clients looking to start OBI initiative:

  1. Hire a small firm instead of Big-3. Your money will be better spent and you will get better ROI even if rates look higher
  2. Insist on client’s recommendations
  3. Review consultant’s profile. This is the most important in my opinion. Every consulting firm has mix of A and C players. You want to get the A players. Here are a couple of things to look for:
  • Certification: Do they have CBIP certification? Are they vendor certified? OBIEE certifications are not out yet, but from what I hear, Oracle is going to come out with it soon.
  • Personal Branding: Does he participate in Forums and Mailing lists: How is the participation level? Does he blog?

Now, I am not suggesting that blogging is a necessary condition, but it is useful nevertheless. I have worked with many super consultants who have never blogged and rarely visit forums. They just don’t have time! And I don’t blame them. With the growing competition, personal branding would no longer be a choice but become a necessity.

November 4, 2008

Open a Linux hosted Repository in Online Mode

Filed under: OBIEE — Prakash @ 3:09 pm

I just stumbled on Kevin’s blog and found detailed screenshots on opening linux-hosted repository in online mode.

You can read Kevin’s blog for screenshots.

October 6, 2008

Where do you want to go?

Filed under: OBIEE — Prakash @ 7:50 pm

Typical BI project conversation:

Client: Here are my five reports that I run on discoverer. We just bought OBIEE and we would like to port it to OBIEE and by the way, it would be great if you can finish it by end of this week.

me: Sure. We can do that, but what about the other 395 reports that you have?

Client: We will get to them when we have budget next year.

This is a perfect recipe for disaster. In trying to save time and money, many IT managers skip requirement gathering altogether and mistakenly equate existing “reports” to BI. OBIEE is just another reporting tool. Yes, it is, but it is so much more or can be so much more. OBIEE implementation is an opportunity to become an intelligent enterprise. Migrating reports as-is without thinking about the end goal will just propagate the mistakes of the past.

This also reminds me of a piece from Alice in wonderland

Alice: ‘Would you tell me, please, which way I ought to go from here?’

‘That depends a good deal on where you want to get to,’ said the Cat.

‘I don’t much care where—-‘ said Alice.

‘Then it doesn’t matter which way you go,’ said the Cat.

September 29, 2008

Discoverer to OBIEE Migration

Filed under: OBIEE — Prakash @ 8:42 pm
Tags: ,

Discoverer to OBIEE Repository migration utility was released with After hearing a lot about it, I decided to try it out.

I exported a simple Discoverer EUL and ran the command line utility (MigrateEUL.exe under oraclebi\server\bin) and I got the converted repository file. I was initially confused about the repository username and password. Turns out, the username was Administrator with no password (same as brand new repository creation, common sense 🙂 ).

I really liked the simple and clean approach to migration. Ofcourse, this utility just accelerates the migration. There is still manual work involved depending on the complexity of your discoverer installation.


– Can only convert from Discoverer

– No workbook migration (In Development as of now.

You can find a very good introduction on OBIEE for Discoverer Users here and here

Blog at