OBIEE Playing With TopN Part 2

In part 1 we ended with:

Let’s try to add the top2 product2 for each customer in the top 10. Start with adding the product column:

You will notice that the revenue for each customer has dropped. This means we first have to “lock” the revenue on a customer / year level:

Okay that fixed, let’s get the revenue by product:

Some how I don’t think this correct. Let’s get the details for one customer:

He has bought several products so let’s tweak this some more. We need to add the TOPN2 Filter for product by customer by year.

Just add as an extra column.

Let’s put it in a pivot to make it even more readable:

Till Next Time