Interview Questions   Tutorials   Discussions   Programs   

Cognos - How can we create top 10 and bottom 10 records in the same list?




700
views
asked mar September 27, 2014 03:35 AM  

How can we create top 10 and bottom 10 records in the same list?


           

1 Answers



 
answered By vishnoiprem   0  

Top 10 always will be on some measure based on some dim not simply top 10 and bottom 10, make q1> get the rank of the measure rank(measure for dim )<=10 make q2 the rank in the desecending order of measure rank(measure for dim desc )<=10 make q3=q1 union q2

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert