This discussion is archived
2 Replies Latest reply: Dec 28, 2012 1:02 AM by sayak RSS

using TOPN reports in OBIEE 11g

sayak Explorer
Currently Being Moderated
Hi ,

I am displaying TOP 4 products (dimension) with highest revenue (measure) in a bar chart . Used TOPN function in the revenue column . But, while displaying 4 bars , the top most product (ranked 1) bar is displayed with data but without any level.

For example , there are 4 products - denim, lee cooper , levis and denim is top's the chart with 1,500 $ ...then I am getting a bar leveled 1 , among 4 bars with the value (1,500 $) but without level (i.e. denim) . Other bars are coming just fine (i.e. lee cooper - 1,200 $, levis - 800$ ) .

Let me know if the problem statement is not clear enough .

Thanks
sayak

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points