I have a derived table in the universe that has fiscal year and fiscal month and I need to sort it and i used the order by
at the end of the query after by group by. The sql works when I execute it against the database through a query tool, but it
does not work in the derived table. I get an error - teradata database syntax error : that order by is not allowed in subqueries: state 42000
There are about 8 fields in my sql and I need to order by dataset by the first 2 fields only. Is there an alternate solution for this?