You can add Order by statement to queries by editing KM.I have edited IKM SQL Control Append to provide Order by.

You can add Order by statement to queries by editing KM.I have edited IKM SQL Control Append to provide Order by. 

1) Add an option to KM named USE_ORDER_BY, its type is Checkbox and default value is False.

This option determines you want an order by statement at your query.

2)Add second option to KM named ORDER_BY, type is Text. You will get order by values to your query by this option.

3) Editing Insert New Rows detail of KM. Adding below three line code after having clause. That's it!

<% if (odiRef.getOption("USE_ORDER_BY").equals("1")) { %>

ORDER BY <%=odiRef.getOption("ORDER_BY")%>

<%} %>

 If USE_ORDER_BY option is not used, empty value of ORDER_BY option get error.

And executions of KM appears as such below;

At this execution, I checked the KM to not get errors if ORDER_BY option value is null.

There is no prove of ORDER BY I'm glad.

 Second execution to get  Order by clause.

Tadaaaa! :)

Note:Editing Knowledge Modules at ODI is developer friendly and ease of use, but sometimes leaving the KM at its own preferable as risk of new versions ODI are supporting the edits at future.