Oracle Business Intelligence OBIEE 101: OBIEE Combine with similar request calculations

Thursday, August 5, 2010

OBIEE has a very powerful option called “Combine with similar request”:

It basicly gives you an option to do an UNION (ALL), INTERSECT or MINUS.

Let’s start with a simple report:

Giving us:

Let’s try to divide the total local amount

First add a new column, in the criteria tab click on next click on giving us:

Let’s enter a name and formula:

The columns are now addressed with the OBIEE internal name starting with SAW_0 on the left side.

Let’s check the result:

Hmmm, not quit what we wanted, let’s add a grand total:

This doesn’t work since we have different years in the first column.

Let’s add a SUM in the calculation:

Giving us an error:

Let’s add a group by for the whole report:

now it works:

Till Next Time