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
