Changing the search defaults - OBIEE 11g

Changing the search defaults - OBIEE 11g

This article describes how to change the search defaults values from "Starts" to "Contains". In production, all users want their default value is "Contains", because it speeds up work in answers/dashboards. This customization was done in OBIEE 11.1.1.7.140715 on RHEL 6.7 server.


This is default in OBIEE portal:

All you must do is change order of one value in file (obips.dropdownsearchdialog.js) specified below:

$OMWHOME/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/analytics_11.1.1/silp1v/war/res/b_mozilla/uicomponents/obips.DropDown/obips.dropdownsearchdialog.js

Please, before starts editing file, make a copy!
In this file find string (without ""):
"c.push(newobips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringStarts").getString(),"beginsWith"));"

As you can see, this string is written before string specified below. Just "cut" string specified below and paste it before string specified above.
"c.push(newobips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringContains").getString(),"contains"));"

If operation was successfull it must be written like this ("..." indicate that this is only part of the string):

... c.push(newobips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringContains").getString(),"contains"));c.push(newobips.FormFields.Option(obiprp.PromptComponents.Utilities.getPromptResource("kmsgSearchStringStarts").getString(),"beginsWith"));
...

 After saving all modifications in file, please restart your OBIEE services from Enterprise Manager Console and when you log in, you can see that default value is "Contains":