Home » Fusion Middleware & Colab Suite » Business Intelligence » TopN analysis not displaying column in rank order for main report (OBIEE11g)
TopN analysis not displaying column in rank order for main report [message #547158] Tue, 13 March 2012 02:06 Go to next message
AnjaliG
Messages: 1
Registered: March 2012
Location: chennai
Junior Member
HI,
For a topN analysis report,
Am using an intermediate report to fetch the top10 countries and connect it to the main report by prompting the country column with the intermediate report.
However in the main report ,the countries fetched, are not dosplayed in rank order.
Please help with this.
Re: TopN analysis not displaying column in rank order for main report [message #562994 is a reply to message #547158] Tue, 07 August 2012 12:27 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Correct, how could it do that? So you have to somehow include an sort order column in your main request, to order by. Sometimes a sum (by dim) can do the trick. I.e. Sum(amount by country). Then even if you gave lots of more detailed columns in your request (like customer name or product group etc), you can still use that sum by as sort order. Hide the sum by column though, sort order will still work.
By the way, if you get this to work, you can most likely get rid of the supporting request, all you need is in the main request then.
Previous Topic: New calculated item positioning
Next Topic: Not enough values in prompts
Goto Forum:
  


Current Time: Tue Jul 29 20:26:01 CDT 2014

Total time taken to generate the page: 0.05621 seconds