Tuesday, June 12, 2012
Case Insensitivity in OBIEE 11g prompts
Had a request to turn on the case insensitive searching in OBIEE 11g today here is how you do it:
1. Add the following entry in instanceconfig.xml: located at
\<MW Home>\instances\<yourinstancename>\config\OracleBIPresentationServicesComponent\coreapplication_obips1
<QueryManager>
<CaseInsensitiveMode>true</CaseInsensitiveMode>
</QueryManager>
Save Instanceconfig.xml file.
2. Open the NQSConfig.ini located in \<MW Home>\instances\<yourinstancename>\config\OracleBIServerComponent\coreapplication_obis1 and search for CASE_SENSITIVE_CHARACTER_COMPARISON and change this values to OFF as shown below.
CASE_SENSITIVE_CHARACTER_COMPARISON = OFF;
Save NQSconfig.ini file.
3. Restart All OBIEE services.
4.Verify setting has taken affect.
Subscribe to:
Post Comments (Atom)
There are certain things I don't want to joke about. If it's about somebody else, it's fine.
ReplyDeleteIf it's about me, I think it's totally insensitive! See the link below for more info.
#insensitive
www.ufgop.org