Home | Ciber
Knowledge page of Ciber Netherlands

OBIEE Playing With TopN Part 1

Basic question Give back the Top10 Customers:

image

Simple add a TopN filter to request:

image

Most manager wonít be satisfied with this report because there isnít a time element present. Letís add a year:

image

image 

Okay what about the top10 for each year? Here is one solution:

First convert the filter to SQL:

image

image

Add a by to the TOPN Part:

TOPN("F1 Revenue"."1-01  Revenue  (Sum All)",10 by "D0 Time"."T05 Per Name Year" ) <= 10

image

image

What about showing the top 2 products for each top10 customer? I will discus that in part2.

Till Next Time

No comments yet. Be the first.

Leave a reply