[OBIEE 11g] Column Format Valure Suppression - Change Default Option

Column Format Value Suppression - Change Default Option

Before modification let us see what we have to achieve.

Take any one presentation column and go to column properties->Column Format

 
The default value of option "Value Suppression" is set to "Suppress"

We have to change this default option to "Repeat"

Edit the java script file formatcolumn.js which is placed at 2 location:

C:\OBIEE11G\Oracle_BI1\bifoundation\web\app\res\b_mozilla\answers  

AND

C:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\b_mozilla\answers

 Change the default value from

var a=XUIGetAttributeString(this.defaultElement.getDefaultFormatting().selectSingleNode
("saw:formatSpec"),"suppress","default");

TO

var a=XUIGetAttributeString(this.defaultElement.getDefaultFormatting().selectSingleNode
("saw:formatSpec"),"repeat","default");

 

Restart the BI services. Reload the metadata. Refresh the browser.

You will find the default value being changed to "Repeat"

Here it is-

 This is the system wide change so remember to take back-up of the files which you are going to modify.