Tuesday, July 26, 2011

OBIEE 10g Pivot Table Row heading

In OBIEE pivot table by default the row heading would be empty. when we use measure labels as shown below




We cannot over write the row heading by default settings, to overwrite it use the following javascript.

Add a static / narrative view in the report and add the javascript.


<script language=javascript>
var arr = new Array();
function overWriteRH()
{
  var arr=document.getElementsByTagName("td");
   for (i=0; i<arr.length; i++)
   {
      if (arr[i].className=="PTRH")
      {
            arr[i].innerText="Measures";
         arr[i].textContent="Measures";  
    
      }
   }
}
overWriteRH();
</script>



Now the row heading will be avilable in the pivot table,



Change the'Measures' in the above code to the value we need to display, also we can format the font as we want using simple HTML tags.


Vino

Monday, July 25, 2011

OBIEE 10g hide Refresh, Printer Friendly and Add to Breifing Book links for specific dashboard

In OBIEE 10g links for Dashboard Refresh, Printer Friendly and Add to Breifing Book were available at bottom of the page by default.



To hide the link for a specific dashboard

Go to Edit Dashboard -> Add a Text box (enable the HTML markup), In that enter the below Java script code.




<script type="text/javascript">

onload=function hideAll()
{
   var body = document.getElementsByTagName('body')[0];
   var spns = body.getElementsByTagName("span");
   var spn;
   for (i = 0; i < spns.length; i++)
    {
      spn = spns[i];
      if(spn.className=='DashboardFormatLinks')
      {
        spn.style.display = "none";
      }
   }
}
</script>


Now the links would be hided.



Vino