Wednesday, November 2, 2011

Referencing session variables in report title


currentTime => @{system.currentTime}
system.productVersion => @{system.productVersion}
session.locale => @{session.locale} = en-gb
session.language => @{session.language} = en
rtl =>@{session.rtl} = false
session.loginTime => @{session.loginTime}
session.logoutTime =>@{session.logoutTime }
session.lastAccessTime =>@{session.lastAccessTime}
session.currentUser => @{session.currentUser.id} = administrator
user.homeDirectory => @{user.homeDirectory} = /users/administrator
user.id => @{user.id} = administrator
user.displayName => @{user.displayName} = administrator

DUMMY Column with NULL Value

Sometimes you need a dummy column in Union (ALL) query's with a NULL value.

This could help in this situation;

CAST(NULL as double)

Wednesday, September 14, 2011

Oracle Business Intelligence Browser Support


Oracle Business Intelligence 10.3.x is supported with following platforms;

Microsoft Windows:       Microsoft Internet Explorer 6.x
                                         Microsoft Internet Explorer 7.x
                                         Firefox 1.5.x
                                         Firefox 2.0
                                         Firefox 3.0

Microsoft Windows Vista:  Microsoft Internet Explorer 7.x

Linux:                                Firefox 2.0

Sun Solaris:                       Firefox 2.0

Apple Mac OS 10.x:         Firefox 2.0


Official word from Oracle is that OBIEE 11g supports Internet Explorer 7.x, 8.x and Firefox 3.5+ and these are certified.

Currently Oracle Business Intelligence is not certified for Microsoft Internet Explorer 9. This can lead to strange behavior when running dashboards and other functionalities.

However most of the problems can be solved by putting Internet Explorer 9 in the compatibility mode using:

Tools > Compatibility view