In some cases, ordering/changing the group by will make alot difference in terms of performance; DB like DB2, Redbrick, Sybase are good examples for this.

we had a requirement in DB2, where Db2 asked us to change the group by order to make the SQL works better.

Solution:

• In the project configuration (project level) –> Report Definition –> SQL Generation –> attribute weights –> <add the attributes in order the way you like to force it in the select clause so that group by will change automatically>
• By combining “Attribute Weights” and the “Max Columns in Index” settings, a user can designate any attribute to be included in the index.

(After a long gap, a short post)

When running a  (Saved with default answers) Ad hoc report that has been re-prompted, the metrics on the resulting report will be displayed in alphabetical order rather than in the order they were selected. 

A possible workaround to this issue is to click and highlight one of the selected metrics , then re-execute the report.

As usual, we are touch base with MicroStrategy (its known issue in 9x, please contact MicroStrategy Tech Support 😛 )