How to modify list of export formats in OBIEE 12c

CP Strother-Oracle

I'm trying to modify the following list of export formats that appear when you click the export link at the bottom an analysis object.

Here's the list that pops up when you click export. I'd like to keep just PDF and Excel as options and remove the rest from the list.

I looked in Dashboard properties and couldn't find anything that allows me to disable certain formats from the list like Web-Archive, Data, Web Archive or Powerpoint.

Does anyone know of a .xml config file on the server that allows me to modify this list, removing certain items?

Thank you for any assistance or suggestions.

Syedsalmancs110

There is no configuration as such available that helps you remove a specific export type specifically, its either hide export option altogether or have everything.

The only option you have is to go down customization road(make changes directly in OBIEE code) which would get rid of non required export options completely i.e. you will not have non required option anymore but only for this particular version as soon as you apply a bundle patch all the options will be back again.

So do you want to go down customization road, FYI it is not a supported or recommended method.

Here are some OBIEE 11g examples for your reference, but remember in 12c file location would be obviously differ and there is good chance that code mentioned in below document might also differ in OBIEE 12c.

So if you plan to play around with out of the box code then make proper backups and then only proceed any further.

OBIEE 11g: How To Remove The MHTML and Data Export Links in OBIEE (Doc ID 2136780.1)

How To Hide The Export To 'Excel 2007+' Option Completely From An Analysis In OBIEE 11g (Doc ID 2068004.1)

CP Strother-Oracle

Hi Syed. Looks like these .xml files have changed in 12c. As I originally suspected it's not a simple config change.  Glad I checked.  Thanks for the feedback.

[Deleted User]

@CP Strother-Oracle Yes the files have changed but the ksmsgs still contain all the necessary tags in viewscontrolmessages.xml

kmsgEVCLinkDownloadExcel

kmsgEVCLinkDownloadData

kmsgEVCLinkDownloadMHTML

kmsgEVCLinkDownloadPDF

kmsgEVCLinkDownloadCSV

kmsgEVCLinkDownloadDataTab

kmsgEVCLinkDownloadXMLFormat

Syem gave you good pointers and MOS Doc 1316529.1 contains the same

CP Strother-Oracle

Hi Christian.  Thanks for the feedback.  Good point.  So, what I did is copied the viewscontrolmessages.xml to my custom messages folder.  Searched for the following names and removed the entire entry between <a ... </a>.

kmsgEVCLinkDownloadPDF

kmsgCatalogActionExportPowerpoint2007

kmsgEVCLinkDownloadMHTML

kmsgEVCLinkDownloadData ( Tip: there's two of these entries.  Ignore the one that ends with "&amp;nbsp;".  Removing it didn't make a difference, but the other entry did!)

Restarted Presentation Services, and now my export list looks like the following.

[Deleted User]

So does this answer your question? If so please mark the appropriate responses as correct or helpful in order for other forum users to be able to benefit from this thread.

Gopi Krishna P

Hi @Christian Berg-0racle

Do you have any idea, in OAS what is the name of these files and also file paths, appreciate if you can suggest on this.

Madasamy -Oracle

@User_DCJG6 I just did a quick search and we still see the files present in OAS 2023

$ORACLE_HOME/bifoundation/web/msgdb/messages/viewscontrolmessages.xml

You can try it out on a sandbox.

Gopi Krishna P

Hi @Madasamy - Oracle-Oracle

Thanks for the response, I am able to see the file now.

in export tab we have two options 1. formatted ,2. Data.

Here I want to display the "formatted" options only.

data option is not required any idea, how to achieve this. below is the piece of script in that viewscontrolmessages.xml XML file,

Thanks in Advance for your help.

<script>function NQCreateTargetList(sFormName)

{

var tForm = document.forms[sFormName];

//var retVal = window.prompt (&#39;<sawm:messageRef name="kmsgTargetListViewName"/> - <sawm:messageRef name="kmsgGeneralFrameName"/>&#39;, &#39;&#39;);

 var retVal = window.prompt (&#39;<sawm:messageRef name="kmsgTargetListViewEnterName"/>&#39;, &#39;&#39;);

if (retVal == null)

{

return;

}

try

{

tForm.ListName.value = retVal;

tForm.action = top.App().GetPageURL();

top.App().SubmitForm (tForm);

}

catch (e)

{

alert(&#39;<sawm:messageRef name="kmsgSiebelNotFound" sawm:use="text"/>&#39;);

}

}</script>