Friday, May 21, 2010

OBIEE Playing With TopN Part 2

In part 1 we ended with:

image

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

image

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:

image

image

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

image

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

image

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.

image

Just add as an extra column.

image

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

image

Till Next Time

No comments: