Tuesday, October 28, 2014

OBIEE 11G " No Result " Custom Message With Icon

o get " No Result " Custom message with information icon like the following image,


Go to results tab, click Edit Analysis Property icon and place the below text in messages section.

<table cellspacing=0 width="300" ><tr>
<td class="ErrorTitle" valign=top ><img src="res/sk_blafp/common/title_info.png">&nbsp;</td><td class="ErrorTitle" align=left>No Results</td></tr><tr>
<td>&nbsp;</td><td class="ErrorInfo">The specified criteria didn't result in any data.<span style="font-size: 6pt;"><br><br></span><font point-size=4><br></font></td></tr>
</table>
<style type="text/css">
td.ResultLinksCell {
display:none;
}
</style>



Try this, It works.

Monday, October 20, 2014

OBIEE 11G Display a list of dashboards based on permissions

A way to display a list of dashboards based on permissions :

Copy and paste the below script in the text box and mark  " Contains HTML" box.

<img id="loading" src="/analytics/res/sk_blafp/catalog/loading-indicator-white.gif" />
<div id="dash_list"></div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<script type="text/javascript">
$.ajaxSetup({
    beforeSend:function(){
        $("#loading").show();
    },
    complete:function(){
        $("#loading").hide();
    }
});
$.ajax({
url: "saw.dll?getDashboardList"
}).done(function( data ) {
    var start = data.indexOf('[');
    var end = data.lastIndexOf(']');
    var len = end-start+1;
    var json_str = data.substr(start,len);
    var json_obj = jQuery.parseJSON(json_str);
    var str = 'You have access to the following dashboards:<br/> <table align="left" border=1>';
   var loopend=0;

str+='<tr>';
    $.each(json_obj, function() {

        if (loopend%5==0)
{
str+='</tr>';
str+='<tr>';
}
loopend++;
        if (this.folderName!=='Welcome'){
            str += '<td valign="top" width="15%" height="15%" ><div style="float:left;margin:5px 10px;";><b>' + this.folderName + '</b><br\>';
            $.each(this.portals, function() {
                    str += '<a href="saw.dll?Dashboard&PortalPath=' + this.portalPath + '">' + this.portalName + '</a><font color="red"> / </font>';
              });
            str += '</div></td>';
        }
    });
str+='</tr>';  
str+='</table>'
$('#dash_list').html(str);
});
</script>

Saturday, October 4, 2014

OBIEE 11G Disabling Right Click On OBIEE With JS

To disable mouse right click in OBIEE dashboards.Place the following Java script in dashboard.
  
<script language=JavaScript>
<!--
var message="Right click Disabled!";

function clickIEbrowser4(){
if (event.button==2){
alert(message);
return false;
}
}
function clickNSbrowser4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}
if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNSbrowser4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIEbrowser4;
}
document.oncontextmenu=new Function("alert(message);return false")
</script>