How to disable order by in jasper server olap functionality?

[murugantevin]

we have alot of data , therefore we need to try and make the performance better , it seems like when we drill through , the query generated to be executed contains all these uneeded order by statements , this is making the query very slow , is there a way to totally disable this or atleast overide this so i can only do an order by maybe on one thing rather than everything like what it is doing now which is pointless?

[kkumlien]

Hi Tevin,

you will need to provide a lot more information for someone to be able to help you.

For example: version of the product, a sample query, maybe a screenshot, etc.

Thanks!