OBIEE Changing unchangeable cells

If you create a pivot view:

Most of the properties can be changed from the pivot view editor:

But they forgot to put an edit box on the top left corner cell:

If you want to set the background color system wide goto the views.css file and change the PTIndentCell:

If you want to change it only for on report add a static text:

add some javaScript like this:

<script type="text/javascript">
var tds = document.getElementsByTagName('td');
var lCSS = new Array();
for(var td=0;td<tds.length;td++){
if( tds[td].className != 'PTIndentCell' ){
continue;
}
tds[td].style.backgroundColor="#CCCC00";
// Info on property naming: http://codepunk.hardwar.org.uk/css2js.htm
lCSS.push(tds[td].innerHTML);
}
for(var len =0; len < lCSS.length; len++){
//document.write("Bingo " + "<BR>");
//debug only
}
</script>

(Yep it’s based on a idea coming from Joe Betram)

Check the contians HTML Markup box:

Check the results:

The naming of CSS properties in javaScript varys slightly from normal CSS: http://codepunk.hardwar.org.uk/css2js.htm

Till Next Time