Thursday, May 26, 2011

OBIEE Catch the {mobile} browser

More people use mobile the device to connect to OBIEE. Since they don’t all have the same capabilities, you might want to catch the browser or device making the request. To get the info add this to a dashboard page:

<div id="example"></div>

<script type="text/javascript">

txt = "<p>Browser CodeName: " + navigator.appCodeName + "</p>";
txt+= "<p>Browser Name: " + navigator.appName + "</p>";
txt+= "<p>Browser Version: " + navigator.appVersion + "</p>";
txt+= "<p>Cookies Enabled: " + navigator.cookieEnabled + "</p>";
txt+= "<p>Platform: " + navigator.platform + "</p>";
txt+= "<p>User-agent header: " + navigator.userAgent + "</p>";
txt+= "<p>screen.width: " + screen.width + "</p>";
txt+= "<p>screen.height: " + screen.height + "</p>";

document.getElementById("example").innerHTML=txt;

</script>

Based one or more criteria you can do a redirect to a more “suitable” dashboard page.

Till Next Time

Monday, May 23, 2011

OBIEE install problems and solutions II

I had to do a install of 11Gr5 on a laptop with windows7 64 bit and ran into a couple of problems. The laptop was/is kind of messed up because I often use it to test and install new version of a product.

Problem OPMNCTL doesn’t start.

Even when everything runs fine after the install it won’t start after a reboot. If you can’t start them from the EM and get message’s like:

  • SEVERE: Element Type: BI_INSTANCE, Element Id: coreapplication, Operation Result: FAILED_TO_….

Go to to <<BI_HOME>>\Oracle_BI1\opmn\bin>

enter OPMNCTL STATUS:

image

Set the variable:

set ORACLE_INSTANCE=D:\OBI1115\instances\instance_1

Start the OPMNCTL:

OPMNCTL STARTALL

Till Next Time

Saturday, May 21, 2011

OBIEE11g install problems and solutions I

I had to do a install of 11Gr5 on a laptop with windows7 64 bit and ran into a couple of problems. The laptop was/is kind of messed up because I often use it to test and install new version of a product.

Problem: Installation freezes in the configuration step.

  • Check if you have a 64 bit java JDK installed:image 

!DON’T look in the program files (X86) directory!

  • Check if your java_home points to the right directory:image

If you have a CLASS_PATH variable see that it points to the right directory, even better if you remove it (temporally) before install.

Till Next Time

Friday, May 20, 2011

OBIEE weblogic password_life_time MDS database

The default password life time on an Oracle 11gr2 database is a 180 days. This means that the connection to your MDS databases in the weblogic server will crash after a 180 days.

Ask your DBA to set it to a longer period FI: 3600 days (almost 10 years)

alter profile default limit password_life_time 3600;

Till Next Time

Tuesday, May 10, 2011

OBIEE11Gr5 iPad app available

It’s released in the Apps store:

image

It works with the 11Gr5 release. It’s much better, still some quirks with dashboard tabs. They are sort of hidden in the top bar.

Here is the documentation:

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/bimobile.htm

After playing around with it last night, I must say it’s a giant leap forward! Way to go Oracle!

Till Next Time

OBIEE11Gr5 Extraction Error Windows

When extracting the downloaded files on windows you might run into an error saying the extracted file path is too long.

image

This can be avoided by extracting the files close to the root of your disk like d:\XTR

Till Next Time

OBIEE 11Gr5 released

You can now download it trough OTN. It is again bigger then the last one (5 parts).

Just my luck: I just finished my presentation for the Rittman Mead BI Conference based on 11Gr3. Some slides need a complete rewrite…..Knipogende emoticon

Till Next Time