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:

Open the second revenue column and change the formula to:

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

Create a Top N filter for the second revenue column:

Switch to PIVOT table:

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

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:

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

Till Next Time