Thursday, December 17, 2009

OBIEE Top N Months across

I was asked how to get the Top 10 customers for the year 2007 and put there revenue per month. First make the basic report and filter, put the revenue column in twice:

image

Open the second revenue column and change the formula to:

image

SUM("F1 Revenue"."1-01  Revenue  (Sum All)" BY "D1 Customer"."C1  Cust Name")

Create a Top N filter for the second revenue column:

image

image

Switch to PIVOT table:

image

Place the columns in the right places, set the aggregation:

image

image

Till Next Time.

OBIEE Making an OR filter

Question I got from the blog, how to make an or filter in OBIEE.

Say you want the revenue for 2008 or the 2007 Q1. First make your report including the filters:

image

Next click “AND” image to change into OR image . This way you can make complex filters:

image

Till Next Time