Character comparion in OBIEE

Disable Case sensitive search or comparison in OBIEE

Requirement: 

1. Disable case sensitive search in obiee prompt

2. Disable case sensitive comparison in obiee 10g / 11g

The CASE_SENSITIVE_CHARACTER_COMPARISON parameter in the NQConfig.ini file controls the case sensitive search within OBIEE. 
The CASE_SENSITIVE_CHARACTER_COMPARISON parameter affects only BI Server setting not the Database.It doesn't affect the DB queries DBA might be have enabled or disabled in database.
Only data that has been cached by the BI Server is affected.

Include the below command in the connection pool of the repository under connection script

Alter session set NLS_SORT=BINARY_CI

Alter session set NLS_COMP=LINGUISTIC

Above problem appeared as data issue in our reports, when we were upgrading our project from OBIEE 10g to 11g then we added above solution in rpd.

Thank You,

Ashish Tiwari