Pages

Sunday, January 13, 2013

OBIEE Pivot Table insert a word in Top Left Cell

Place static code in Answers Request or Dashboard "Contains HTML"



 <script  type="text/javascript"  language="javascript">
window.setTimeout(InsertText,100);
function InsertText() {
   if (document.body!=null)
  {
    var cols = document.getElementsByTagName('td');
      for (var x=0; x<cols.length; x++) {
  if (cols[x].className == 'PTCC' && cols[x].innerHTML.indexOf('')!=-1)
    cols[x].innerHTML = 'PIVOT TABLE';
}
 
   } else {
      window.setTimeout(InsertText,100);
   }
}
</script>
<style type="text/css">
.PTCC
{          
             color:#335C85;
             background-color:#ffff99;
             font-family:Arial;
             font-size:8pt;
             font-weight:bold;
             text-align:center;         
}       
</style>


Replace the class name PTCC with the appropriate class name using page source.

Eg:

1 comment:

  1. do you know why it also changes all the other analyses on a dashboard even though they are not part of the analysis with the static text? if so, how to fix?

    ReplyDelete