2 Replies Latest reply: Dec 28, 2012 3:02 AM by sayak RSS

    using TOPN reports in OBIEE 11g

    sayak
      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