Column Format Value Suppression - Change Default Option

Requirement is to change the default option - Suppress in the Column Format Value Suppression to Repeat.
This is with reference to this OTN POST.

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.

Thank you.



3 comments:

Anonymous said...

Good find. Have a question though. If I want to do this for only one subject area. How can we do it ?

IS there a way . I don't want this setting for all columns/subject areas and don't want to dit manually.

Nachiket Mehendale said...

Can't test and play around :-( I am Not in OBIEE for some time. :-(
But it does not seem possible for me at this moment to change that option only for one SA.

Anonymous said...

I tried this... but this did not work... I am still getting Suppress as default in answers.