OBI EE 12c - Changing search defaults

This article describes how to modify the search defaults in OBIEE 12c (12.2.1.0.0 and 12.2.1.1.0) from „Starts“ to „Contains“ and un-check „Match case“ mark which is checked in default. 

You must know that all files you modify in steps described below will be replaced when you apply new patch in the future. In that situation is better first to backup files you have modified before and replace files might changed after patching. 

First, we must backup files we are going to change.

Our „OMW_HOME“ is located on „/ora01/omw“ – please modify this path with yours Oracle Middleware home and locate following files:

• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/za01ic/war/res/b_mozilla/common/availabledatabrowser.js
• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/eiguw6/war/res/b_mozilla/common/availabledatabrowser.js
• $OMW_HOME/user_projects/domains/bi/servers/obips1/tmp/earmanager/analytics/MQxEfhyTZomEwq1mWe+CHA/res/b_mozilla/common/availabledatabrowser.js
• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/za01ic/war/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js
• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/eiguw6/war/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js
• $OMW_HOME/user_projects/domains/bi/servers/obips1/tmp/earmanager/analytics/MQxEfhyTZomEwq1mWe+CHA/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js

Open and edit each file specified above with text editor like „VI“ (on Linux) or „Notepad++“ (on Windows). When you open file(s) find string (you can copy string from here):

d.push(new obips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringContains").getString(),"contains"));

If you look better, you will see that string before that above is this below:

d.push(new obips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringStarts").getString(),"beginsWith"));

All you must do is to change order between this two strings („contains“ must be before „beginsWith“). If everything is done correctly, finally your strings must be same as this below:

d.push(new obips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringContains").getString(),"contains"));d.push(new obips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringStarts").getString(),"beginsWith"));

Repeat the same procedure in the remaining 5 file's specified above.

Second thing we must do is to un-check „Match case“ mark. Procedure is similar like procedure before. First, locate three files („obips.dropdownsearchdialog.js“):

·   

• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/za01ic/war/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js
• $OMW_HOME/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/analytics/eiguw6/war/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js
• $OMW_HOME/user_projects/domains/bi/servers/obips1/tmp/earmanager/analytics/MQxEfhyTZomEwq1mWe+CHA/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js

      

Open and edit each file specified above with text editor. 

First, in each file find this string:

{var c=this.bCaseInsensitiveSearch;var d=this.bCaseInsensitiveSearch;this.matchCase=new obips.FormFields.Checkbox("matchCase","matchCase","matchCase",obiprp.PromptComponents.Utilities.getPromptResource("kmsgSelectionsMatchCase").getString(),d,c);

All you must do is to change part of string which is above highlighted in red, to "false". If you did everything correct, your string finally must be:

{var c=this.bCaseInsensitiveSearch;var d=false;this.matchCase=new obips.FormFields.Checkbox("matchCase","matchCase","matchCase",obiprp.PromptComponents.Utilities.getPromptResource("kmsgSelectionsMatchCase").getString(),d,c);

After all changes restart complete BI services and clear complete BI cache.

Result is:

Enjoy!