Analytics Resources: Insights, Best Practices,

Case Studies and More

close
Written by Umesh Kakkad
on November 27, 2013

 

One of my colleague was designing the dashboard which has multiple reports and these reports data will be displayed based on data level security. He doesn’t want to display any content from no results view even “Refresh” button.

He was able to remove all the content from No Results view but could not remove the refresh button. He then asked me to help him on this.

I am fascinated in UI design using Java, Javascript, CSS. Coming to the point, here we go to hide Refresh button.

There are two ways you can hide this, one is hide globally using below steps.

Navigate to <ORACLE_BI_HOME>Oracle_BI1bifoundationwebmsgdbl_enmessages

Take copy of viewmessages.xml to viewmessages.xml_backup

Edit the viewmessages.xml

Find “Refresh” : <WebMessage name="kmsgEVCLinkRefresh"><HTML>Refresh</HTML></WebMessage>

Remove the HTML section, so it'll be: <WebMessage name="kmsgEVCLinkRefresh"></WebMessage>

Restart the presentation services

But my friend is not interested to hide globally, want to do on particular dashboard only, I gave him to use below Javascript.

This works like this, you have find the Result button html tag, and then hide it.

<script type="text/javascript">
<!--
function hideRefresh(){
var cols = document.getElementsByTagName('td');
for (i=0; i<cols.length; i++) {
if (cols[i].className == 'ResultLinksCell' && cols[i].innerHTML.indexOf('Refresh')!=-1)
cols[i].innerHTML = '';
}}
window.onload= hideRefresh;
//-->
</script>​

Put this script in Report Analysis Properties like below. Now save your report and verify in dashboards.

RefreshButton

You may also like:

Data Modeling Business Intelligence PowerBI

Dimension Specific Aggregation in Power BI

When dealing with facts and measures in any BI tool, you can set the aggregation method (such as sum, count, average etc...

Oracle BI Applications Data Modeling OBIEE 12c

eBusiness Suite and Oracle BI Applications Security

By default, an Oracle Business Intelligence installation is configured with an authentication provider that uses the Ora...

Data Modeling Oracle DB OBIEE 12c

Standard Date Dimension Build

The SQL Below generates a date dimension table where the DATE_WID is a chronological key. This is essential for getting ...