Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Customizing Download Links

Posted by Venkatakrishnan J on January 3, 2008

Lets look at how to go about customizing the download links of reports today. Basically our aim is to customize the list of links that one would get by clicking on the download link. Some organizations might want to impose strict rules on the users by restricting the possible download options. For example one might not want to have the Download to powerpoint and Download to Excel options. Lets see how to go about achieving this step by step.

1.   First let us see include a report in the dashboard with the Download Option enabled. Our aim is to remove the top 2 download options i.e “Download to Powerpoint” and “Download to Excel”

      

2.   Go to {OracleBI}\web\msgdb\messages folder. You would find a file called as viewscontrolmessages.xml. Copy this file and paste it into {OracleBIData}\web\msgdb\customMessages (if you do not have this folder then create it). We are copying this file to override certain messages that produce the download options.

3.   Open this copied file in a text editor and search for the web message kmsgEVCDownloadLinks. You would find something like this

      

4.   Now arrange this webmessage in a format we can understand like the one below.

      

If you notice you would find messages pointing to each of the download links (the ones that have a class NQWMenuItem attached to itself). Now remove the 2 lines (starting from <a> to <\a> corresponding to kmsgEVCLinkDownloadExcel and kmsgEVCLinkDownloadPowerpoint web messages)

     

5.   Save the file and restart presentation services. You would now see that you would not be having the Download to Powerpoint and Download to Excel

     

Advertisements

4 Responses to “Oracle BI EE 10.1.3.3/2 – Customizing Download Links”

  1. Niehaves, Christian said

    Hi Venkat,
    is there any possibilty to change the format of the power point export? For example, I would like to change the default font family within the power point export.

    Thanks in Advance
    Christian Niehaves

  2. Samuel said

    Hi Venkat,

    How could I make a Download link that downloads the result as a semicolon separated file ?
    I have managed to create a commma separated file by entering the following in the file “viewscontrolmessages.xml”:

    Download CSV

    But is there a possibility to change the “Format” to semicolon ?

    Regards
    /Samuel

  3. Samuel said

    Hi Venkat,

    How could I make a Download link that downloads the result as a semicolon separated file ?
    I have managed to create a commma separated file by entering the following in the file “viewscontrolmessages.xml”:

    …a class=”NQWMenuItem” name=”SectionElements”
    href=”javascript:void(null);” onclick=”NQWClearActiveMenu();
    Download(‘@{command}&Format=csv&Extension=.csv’)”>Download CSV…

    But is there a possibility to change the “Format” to semicolon ?

    Regards
    /Samuel

  4. Meir smaja said

    Hi,
    I have one more question regarding this Download links.
    Is it possible to have the download links as default for all sections instead of going to each section in the dashboard and add the links manual?

    this is the behavior my client whants to have and I can’t find this option,
    Is there an option to change the JS files or something?

    Thanks in advance,
    Meir

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: