Friday, June 19, 2009

OBIEE Remote Admintool login problems

A colleague had a weird problem, he was trying to logon  with the admintool to a remote BI server over the ODBC connection.

image 

 

image

The credentials were ok, so the problem must be something else.

Checking the ODBC manager revealed that he was using a ODBC with a space in the name “Server 01”

image

A close look a the connection selection screen of the admin tool revealed that OBIEE “translated” the space to an underscore:

image

Seems you can’t use space in the ODBC connection, use underscores instead.

Till Next Time

1 comment:

Siddhartha said...

John,

The "translation" feature exists in the GO URL facility as well. When I tried to execute a custom button with a GO URL that calls an answer code with multiple string arguments containing spaces, they matched even the results that has "underscore" in stead of spaces in the database. I tried to replicate the reverse behavior and was able to replicate this only once. For some reason, this did not work for the second time. The button was created as a result of custom HTML code in the narration view in a complex view.