Home | Ciber
Knowledge page of Ciber Netherlands

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

1 Comment so far

  1. ramu March 6th, 2013 6:59

    im new to obiee, this is good but not clear, im confused from “Some how I donÔŅĹt think this correct. LetÔŅĹs get the details for one customer:” how did u get the single customer dat ? and where did u apply the topn and what is the extra column metric u taken.

    thanks,

Leave a reply