Registration for the 2012 RM BI Forum in Atlanta, GA and Brighton, UK May 2012 is now open!

The Registration for the 2012 RM BI Forum in Atlanta, GA and Brighton, UK May 2012 is now open! Thanks to the guys over at Rittman Mead I got the opportunity to speak at the Rittman Mead BI Forum 2012 in Brighton. I will do an Ignite-style session; “Oracle BI Applications: Can we make it worth the Purchase?”

The agenda for Rittman Mead BI Forum 2012 will be as follows.

  • Day 1 (Tuesday): Optional OBIEE 11g Masterclass with Kevin McGinley
  • Day 2 (Wednesday): BI Forum Day 1
  • Day 3 (Thursday): BI Forum Day 2
  • Day 4 (Friday): Optional, Free BI Developer (NDA) Day in Conjunction with Oracle BI Product Development

Check for more details here.

Hope to see you in May!!

Expert Status on OTN

Kranthi K has been kind enough to create a special OTN Forum item because of the fact I have reached the ‘Expert’-level status. Thanks Kranthi for doing this. It’s nice to see when people are appreciating the things you do.

Unfortunately I had to change my email-address lately. I thought that wouldn’t be a problem. Wrong!! When you change your email-address, Oracle creates a new profile for you. So my old ‘Expert’-profile looks like this:

I used to be a person, but I am a number now………….

As from now on I have a second profile. I am a name again…….but a ‘Newbie’.

Hopefully those two profiles can be merged. Otherwise I will have a long way to go, to reach the ‘Expert’-level status again. I might be the first one reaching this level twice.

Connect to the Database from Oracle BI 11g

I ran into the following issue when I upgraded from Oracle BI 10g to Oracle BI 11g. Although the upgrade went smoothly, all of a sudden I was not able to reach the database anymore. After doing some research on the internet I stumbled upon the following thread on OTN.

The main difference between Oracle BI 10g and Oracle BI 11g is the fact that Oracle BI 11g has it’s own Oracle_Home.

Thanks to Dirk and Venkat for the possible solutions:


navigate to; {ORACLE_INSTANCE}\bifoundation\OracleBIApplication\coreapplication\setup,

alter user.cmd or depending on your OS,

set your TNS_ADMIN location to point to; {MIDDLEWARE_HOME}\Oracle_BI1\network\admin


Copy your tnsnames.ora to {MIDDLEWARE_HOME}\Oracle_BI1\network\admin directory


Use the full expanded tnsnames as shown below and use this one as the datasource name in your Connection Pool:

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host_name/ip_address)(PORT = port_number))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = service_name)))

Oracle BI Forum

Last weekend I was surprised to see someone’s comment on the Oracle BI Forum on OTN. The fact that someone posted the question in the first place had surprised  me already. But the response to one of the top contributors of this forum is definitely a sign of disrespect. On top top of that, it was his / her first post and he / she did it anonymously.

Asking for interview questions is, in my opinion, not what an Oracle Discussion Forum is all about. As you can see in the thread , I am not te only one who’s at least surprised about the question. I think it is a sign of lazyness. Don’t get me wrong, I love being lazy. Just laying laying on the couch and watching a Blue-Ray movie is one of  my favourite pastimes. The difference is that I don’t ask anyone money for that

It’s true what Christian B. states in his comment; “If you want to learn interview questions by heart just to win a position…that’s not the way to go. Basically you’re cheating both your client and yourself.”. Your employer or your client wants to pay you because you have a certain level of knowledge and not because you can remember the answer to a few questions.

Also the contribution of Christian T. is very valuable; “I could also add to all the above that instead of posting a question, why don’t you try to answer 30 or so unanswered forum questions and take them as your interview training. If you know the answer you will be helping someone else. If you don’t know the answer you can research the subject and be better prepared for your interview. There is no cheat sheet for learning OBIEE, it’s a hard and slow process.”

Last but not least Alistair’s suggestion to just Fuckin’ Google It isn’t so bad after all.

Since Oracle aquired Siebel and I got in contact with Siebel Analytics, I have spend a lot of time exchanging knowledge.  Still I am using the internet; Google, My Oracle Support and the OTN Forums on a daily basis.

If I go back to the list of top contributors on the Oracle Forum I can tell for a fact, that it takes a lot of time to answer questions. The number 10 the rank has at least answered around 130 questions (10 points for a correct answer). He probably has answered lots more 

 Answering questions force you to think about what you are writing down, because you have to make your point in a few words.

 It’s easy to just ask, but why not doing some research yourself. Why does someone else has to do the ‘dirty’ work.

That’s also one of te good things about the OBIEE Enterprise Methodology Group. This is not a ‘How To’-forum, but a place to exchange knowledge about architecture and design; The ‘big picture’ .

The succes of a forum is determined by the willingness to share ones knowledge. Do not keep all the knowledge to yourself. It is a matter of give and take. If you are willing to share your knowledge, then it’s easier to ask for help. An easy thank you or in the case of the Oracle BI Forums; awarding points, keeps the spirit high enough to answer questions.