Skip to Content
Former Member
Nov 07, 2007 at 04:20 AM

Sorting Using QAAWS


We are currently using Xcelsius against a BusinessObjects universe via the recently released QAAWS (Query as a Web Service). The problem is QAAWS does not provide a sorting feature. As workarounds, we have tried Derived tables in the universe as well as building views both of which provide inconsistent results. That is, sometimes they sort, sometimes not. Besides them not working to our satisfaction, I am not big on either of these approaches. I have also heard that you can use End SQL to accomplish this. Is there anyone who has done this successfully or know how to get sorted results into Xcelcius.