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

OBIEE Show Thousands Separator in Chart

A customer wantend no thousand seperator by default for the y-axis in there graphs:

This is very easy when add: ShowThousandsSeparator='False' in the ValueScale tag in the PCXML file of the graph

Till Next Time

OBIEE update tutorials

The people at OTN have updated "Oracle by example" section for OBIEE:

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/index.html

Till Next Time

OBIEE ReportAggregateEnabled

My list of things I want to blog about is getting hugher every day. Today it stands at 32. As with most bloggers my biggest problem is R&D time. Luckily more and more people start blogging on OBIEE.
One of those people is Kevin Custer. He made a great entry on "ReportAggregateEnabled" here: http://oraclebi.soundvoid.net/2008/10/grand-totals-with-calculated-columns-2/. This is one of those things you have look at when you work "complex" grand totals. It is not in the documentation only on metalink3 : SR 3-159350471



Till Next Time

OBIEE Multiple Java Versions

Noticed today that OBIEE doesn't really like having multiple Java versions assigned, when updating from 3.3.x to 3.4.x be sure to point to the orignal JDK. You can find the original loaction in the instanceconfig.xml between the JavaHome tags.

Till Next Time

OBIEE the "developersprompt"

When I'm developing a dashboard I often want to play around with some basic settings like cache hit & seed and loglevel. Normally you have go back to answers or your administration panel to change these settings (temporarily). I always advice my developers to make a 'developersprompt'......It's a simple LOV prompt which returns me 3 presentation variables (dp_cache{0,1}, dp_seed{0,1} and dp_log{0,1,2}.

In the prefix of each report we default add:

SET VARIABLE DISABLE_CACHE_HIT = @{dp_cache}{0}, DISABLE_CACHE_SEED = @{dp_seed}{0}, LOGLEVEL = @{dp_log}{0};
(you can find the postfix block in the advanced tab of your report)

When developing your dashboard you can playaround with different settings to find the optimum. Leave the prompt on the dashboard and make in only 'available' for administrators or developers, so that in time of "trouble" your are quickly able to bypass the cache or turn on logging.

Till Next Time