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:
Let’s try to divide the total local amount
The columns are now addressed with the OBIEE internal name starting with SAW_0 on the left side.
Let’s check the result:
This doesn’t work since we have different years in the first column.
Let’s add a SUM in the calculation:
Let’s add a group by for the whole report:
now it works:
Till Next Time