Bug 18098940 : OPTION TO CHANGE VALUE SUPPRESSION FROM SUPPRESS TO REPEAT AT RUN TIME

Charles M

Hi All.

I believe others have looked and/or are looking to figure this out. I have tried as well, without success (based on what I could find in the community, and from blogs). I did also open a service request to verify that the bug mentioned in the subject line has not yet been fixed.

The reply went something like this:

The bug you reference was filed as a Enhancement request filed against Oracle Business Intelligence.

This ER will need to be reviewed and considered by Development for a future release. It will remain open until it is either incorporated into the product, or it is deemed not feasible. 

...

The ER was filed 2 years ago against OBIEE 11.1.1.7.

I will add you as interested party to this Enhancement.

...

The current supported way is to modify each report one at a time.

Doc ID 1622123.1 basically says the same thing.

How can you suppress or repeat the values of a column dynamically while running the report by clicking on the column header.
At the moment, you have to column properties(in the Criteria tab), and, in the column format, change the value suppression to suppress or repeat.

This functionality does not currently exist.

I have attempted to modify the formatcolumn.js file(s) that I could find. On my system, these are (this is a search from the $MW_HOME):

> find . -name *formatcolumn.js*

./instances/<instance_name>/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/earmanager/analytics/1NvOlOLn45TEA+vPAb0vVw/res/b_mozilla/answers/formatcolumn.js

./user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7arqd/war/res/b_mozilla/answers/formatcolumn.js

./user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/answers/formatcolumn.js

For each of the above files, I changed:

var a=XUIGetAttributeString(this.def

aultElement?this.defaultElement.getDefaultFormatting().selectSingleNode("saw:formatSpec"):null,"suppress","default");NQWSetRadioGroupValue(this.form.elements.Suppress,a);

to

var a=XUIGetAttributeString(this.def

aultElement?this.defaultElement.getDefaultFormatting().selectSingleNode("saw:formatSpec"):null,"repeat","default");NQWSetRadioGroupValue(this.form.elements.Suppress,a);

I even tried changing both of the "supress" strings:

var a=XUIGetAttributeString(this.def

aultElement?this.defaultElement.getDefaultFormatting().selectSingleNode("saw:formatSpec"):null,"repeat","default");NQWSetRadioGroupValue(this.form.elements.Repeat,a);

I then restarted all of the bi components, reloaded the metadata, and refreshed the browser. No change in the behavior:

Note: One thing I noticed about the location of the files I modified, is that they look like they are under some kind of 'tmp' sub-directory. Does that mean they are tempory? Are they compiled, in some way, from something else?

Please let me know if there is anything else I can try for this.

Thanks to all who participate here.

Regards,

Charles

Version: OBIA 11.1.1.10.1 [DB 11.2.0.4] / ODI version 11.1.1.9

Gianni Ceresa

Hi,

There are good ways to customize OBIEE and the "I give it a try and cross my fingers" way.

You used the second

The files you edited are the result of when OBIEE extract EAR archives and deploy components, but will be deleted and replaced every time the component is deployed again.

What you need is a custom style/skin located in it's own location and there you can "extend / override" the default files by customizing what you want and when you then tell OBIEE (configure it) to use your custom style/skin it will use your files.

Look in the doc on how to create a custom style/skin.