Business Intelligence

The cache is accessed when users make requests in Answers. This is not the same cache that is accessed by the Oracle BI Server. You can change the internal defaults by modifying the Oracle BI Presentation Services configuration file (instanceconfig.xml) to add the cache entries.
First of all try to have your presentation Cache on the [...]

(Direct answer: No )
Have a look at this table:

What I’m looking for is this:

But I don’t want to use outerjoins, since obiee messes them up anyway when you try do filtering later on.
Here is a small Q&D trick
Add an extra fact column and multiply it with a random number:

Next hide the [...]

Sunil wrote a good one:
http://sranka.wordpress.com/2008/11/09/how-to-replace-multi-go-button-prompt-by-one/
Till Next Time

First of all in an "ideal" DWH you wouldn’t have a need for outerjoins, but sometimes you need to make data visible which you don’t have.
Outerjoins in OBIEE can be a bit tricky and don’t always give you the result you would expect. In this article I will get trough the basics, in a next [...]

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, [...]

I’ve been meaning to post this for a couple of months now, but we’ve recently grown our team at Rittman Mead and taken on two new Principal Consultants, Jennifer Albu and Ragnar Wessels, bringing our consulting team up to six full-timers.
Jennifer comes to us from a major IT services provider and specialises in Informatica, Warehouse [...]

It’s just a few weeks now until the user group event of the year, the UK Oracle User Group Conference & Exhibition 2009. This year, as well as presenting at the conference we will have a stand in the exhibition hall, where we’ll be demonstrating all the latest Oracle BI&DW tools and answering any development [...]

In my Blog post on End-to-end data quality I mentioned the desirability of fixing bad data at source. This certainly attracted comment both here and on other blogs for example
One point to keep in mind about fixing bad data on the source; it is just that, fixing DATA. We are not fixing bad applications [...]

If you didn’t make it to the last SQLBits (yeah, I know you had a good excuse: it was on a Saturday and you had to wash your hair, or your wife doesn’t let you out on weekends, or you live in Nebraska) then you’re in luck: a film crew from Microsoft filmed most of [...]

I’ve just been told that "MDX Solutions" has been translated into Chinese:http://www.amazon.cn/mn/detailApp?qid=1226604599&ref=SR&sr=13-1&uid=168-2365553-3706601&prodid=bkbk863548#
It’s a shame that Wiley aren’t interested in doing a third edition at the moment, but luckily not much has changed in MDX between AS2005 and AS2008 so the content is still relevant. I see there’s some competition coming in the future from [...]