OBIEE11g Customizing

Download this info from Oracle: http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf

Till Next Time

OBIEE Adding Image to Column Header

Or how to make this:

Goto your column header format:

Put a space in both your table heading and Column Heading, check the custom headings box.

Press the format button for the column heading:

Add some custom CSS:

like :

[code]

background-image:url('res/sk_oracle10/answers/abbcompound.gif');background-repeat:no-repeat;height:30px;

[/code]

Check the results:

Till Next Time

OBIEE Guide user to help text

On most dashboards there is a “general” page with a “help” text regarding de dashboards. A nice cosmetic trick is to change the mouse icon when a user approaches the help link:

Just add some custom css to the dashboard:

[code]

cursor:help

[/code]

Till Next Time

OBIEE Chancing CSS style on the fly

One of our customers wanted to see some suggested CSS changes on the fly on actual reports. The wanted it on the production machine…

First we copied the Demo file to a new folder on the OC4J webserver:

On the demo report we added a static textbox:

Put in the reference to the alternate stylesheets:

<link rel="stylesheet" type="text/css" title="Standard"
    href="res/s_oracle10/b_mozilla_4/views.css">
<link rel="alternate stylesheet" type="text/css" title="Red"
    href="res/Demo/views2.css">
<link rel="alternate stylesheet" type="text/css" title="Green"
    href="res/Demo/views3.css">
<meta http-equiv="Default-Style" content="Standard">

If you now open the report in FireFox and goto view => page style

  (sorry only got the Dutch version installed)

And select the style you want to demo:

  = Default

= Red

= Green

Yes this trick will only work in FireFox (View | Page Style), Opera (View | Style), Konqueror(View | Use StyleSheet), Workarounds for IExplorer are widely spread on the net. Haven’t found it in Chrome Yet

Till Next Time

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

OBIEE Hide the saved filter view link

In this article: http://oraclebiblog.blogspot.com/2009/07/how-to-hide-saved-filter-view-link.html John Andrzejek shows a way of doing this by editing a CSS file.

I prefer editing the viewmessages.xml.

Remove the text between the kmsgViewSavedFilterAnchorText tags. (you have to do this for every languages you use).

Till Next Time

Edit: Stijn found the orignal : http://obiee101.blogspot.com/2008/08/obiee-difference-between-two-rows.html

OBIEE Cool CSS trick

Check out this one from fiston :

http://obieestuff.blogspot.com/2009/07/htmlcss-trick.html

Till Next Time

OBIEE get Internet Explorer Developer Toolbar

Thanks to Christian I found one for Firefox: http://obiee101.blogspot.com/2009/04/obiee-get-firebug.html.
Turns out there is one for IE also:
http://www.microsoft.com/downloadS/details.aspx?familyid=E59C3964-672D-4511-BB3E-2D5E1DB91038&displaylang=en

Till Next Time

OBIEE views.css color cheat sheet

a small cheat sheet on the default colors used in OBIEE in the views.css:

OBIEE s(k)_Oracle10 Colorscheme :

Color:	Hex of color
	#2b7c92
	#000099
	#FFFFFF
	#003399
	#c9cbd3
	#3c3c3c
	#DDEEFF
	#3a5a87
	#E7EAEE
	#DDE0E4
	#B7B7B7
	#D3D6DA
	#C9CCD0
	#48648d
	#C4D5E6
	#BACBDC
	#B0C1D2
	#A6B7C8
	#48648d
	#f2f5f9
	#ECEFF3
	#E2E5E9
	#D8DBDF
	#CED1D5
	#C4C7CB
	#BFC2C6
	#BCBCBC
	#cfe0f1
	#a3bed8
	#333399
	#003366
	#f2f5f9
	#000066
	#000000
	#666666
	#F7F7F7
	#CCCCCC
	#DDDDDD
	#999999
	#a3c2df
	#3c3c3c
	#2b7c92
	#F5F5F5
	#BF2C2C
	#FBEA7B
	#54A36A
	#DEDEDE
	#FFFFE1
	#CCCC00

Till Next Time

OBIEE "Greenbar" Customization

Green bar reporting is alternating the row background colour every odd and even row:

You can switch this on the report view:

The colour of the "Even" row is control by views.css:

" TABLE.ResultsTable TD.ECell"

The colour of the "Odd" rows is controlled by the default background-colour of the table:

But chancing this will also change the "normal" background-color of the cell.

You can avoid this by adding a extra "TABLE.ResultsTable TD.OCell" just below the TD.ECell in the views.ccs:

That way you can use both styles without them influencing each other:

Till Next Time

OBIEE Prompts putting the label in front part 2

In a previous article I showed you how to get from this:

to this:

based on an OTN entry from Stijn Gabriels.

But what if you only want this effect for 1 dashboard page or when you don't have easy access to the views.css?

Simple add a text frame to your dashboard page:

And set the content to:

<style type="text/css">
td.GFPFilter br { display:none; }
</style>

don't forget the "Contains HTML Markup" chechkbox.

Till Next Time

OBIEE Prompts putting the label in front

Or how to get from this:

to this:

It was a question raised on the OTN forum: http://forums.oracle.com/forums/thread.jspa?threadID=886991

And to be quit honest I didn't think it was possible...

But Stijn Gabriels, one of the great OBIEE CSS gurus, came with a very elegant solution. Goto the views.css of the style you are using (S_ directory) and add

td.GFPFilter br { display:none; }

If you are using OC4J as webserver sync the files in the J2EE container.

Till Next Time

OBIEE Get the FireBug!

A tip I got from Christian: If you are playing around with CSS files get the FireBug for FireFox:

https://addons.mozilla.org/nl/firefox/addon/1843

It's a very handy tool to find which CSS class is controlling which part in your report.

Till Next Time

OBIEE hidden column writeback

Sometimes you want to use a "hidden" column for a writeback procedure. Problem is if you use the conventional Hide properties of a column it's also not visible for the write back.

Workaround: use a CSS hide:

Enable the "Use Custom CSS Style " enter display:none. Both for the field and the header.

(Be aware the original value is still available in the source of the page!)

Till Next Time

OBIEE Editing system wide defaults

Setting a system wide default can be very handy but also completely F@#$K up your system. For instance changes to CSS files don't seem to work. Most catalog administrators forget to retract this privileges until it's to late.

Anyway here is how you can undo the damage.

As always be careful when editing directly into the catalog XML.. Backup!

Open the catalog in a off line mode:

Navigate to /system/metadata

Press Edit XML

Press again Edit

Carefully Delete edit the XML  !

Press save, close catalog manager, restart presentation service.

Till Next Time

OBIEE Hidding a section

Sometime you need to hide a section on a dashboard (temporarily)

Go to the "Format Section" part of your dashboard section:

Open the "Custom CSS Style Options

"

Enable the "Use Custom CSS Style " enter display:none

Till Next Time

OBIEE Default colour Title border

Good a quick question on how to set the default Titleborder colour in OBIEE to red.

Go to your view.css directory in ..s_MyCompagny\b_mozilla_4

Locate this part and change the colour:

/* ***** */
/* Title */
/* ***** */

.TitleTable {
    font-family: arial, helvetica, sans-serif;
    border-width: 0 0 4px 0;
    border-style: solid;
    border-color: #FF0000;
}

If you are on OC4J don't forget it to copy to applications directory: ...oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_MyCompagny\b_mozilla_4

Till Next Time

OBIEE Skin and Style Naming

Discovered today that you can't use underscores or in Skin and StyleNames.
so MyCompagny_SKIN_A and "MyCompagny SKIN A" are illegal . MyCompagnySKINA is allowed.

(yep, I know it's in the documentation........)

Till Next Time

OBIEE Portal customization part 2 "the portalcontent"

After the Login screen (http://obiee101.blogspot.com/2008/09/obiee-making-custom-log-on-and-log-off.html) and the portalbanner (http://obiee101.blogspot.com/2008/09/obiee-portal-customization-part-1.html) it's time for the portalcontent. Most of this screenpart is controlled by portalcontent.css.
Active Tab:


Appearance: portalcontent.css => .TabHiFont
Inactive Tab:
Appearance: portalcontent.css => a.TabDimFont
Space between tabs:

Appearance: portalcontent.css => .TabSep
Thickness of the bar below the tabs:

Appearance: portalcontent.css => .TabLineTable
Tab Background image's

Appearance: .TabHiCell, .TabHiSep, .TabDimCell, .TabDimSep
Minibuttons:

Appearance: portalcontent.css => .minibuttonOn
Dashboard Sections:



Of course this posting doesn't include all possible CSS settings but it gives you a good starting point.

Till Next Time

This article was original written for the Ciber Knowledge Blog:

http://knowledge.ciber.nl/weblog/?p=137