Calculating the variances between the column sections in Pivot table

In the below report, we have a very standard pivot view which separates time based measures by dates in columns, and then applies a subtotal at column section level. Now what if instead of doing totaling on the 2 dates' measure, I want to apply variance between the two as indicated below?The main challenge here is that all the values for different dates are all coming from the same table columns, it only appears to be different physical columns...

Read More

The fundamental understanding of Oracle Business Intelligence

There has been many times when during the interview I have asked or been asked the question "Could you explain to me what is OBIEE and what does it do?" This sounds like a really basic question that anybody can start with, which can also lead to so many different topics depending on the answers. I think this is worth blogging for specially after having had so many interviews or project related discussions with other professionals that have missed the point when speaking of OBIEE or even the topic of 'business intelligence' in general.One of the...

Read More