OBIEE Configuring Case Insensitive Search

If you look in the configuration guide you will find that the CASE_SENSITIVE_CHARACTER_COMPARISON parameter in the NQConfig file controls the case sensitive search within OBIEE. Be aware that you might be fooled by your database settings. If you are on an Oracle database 10G+ you can use a connection script in the repository to allow case insensitive searches. Go to the connection pool, click on the connection script tab.

Press New:

Enter:

alter session set NLS_SORT=BINARY_CI
alter session set NLS_COMP=LINGUISTIC

Save the repository, reboot the BI-Server

Till Next Time

OBIEE referencing session variables in report title

After spending way to much time figering out the exact lingo, I decided to blog them for futher reference:

• 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