Skip to Content
0
Former Member
Nov 14, 2011 at 06:39 PM

UNiverse designer sort order

120 Views

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?

fiscal year starts in Jun and ends

in July.

Expected sort order - sample values:

Fiscal year Fiscal Month

2011 5

2011 5

2011 6

2011 7

2011 8

2011 9

2011 10

2011 11

2011 12

2012 1

2012 2

2012 3

2012 4

2012 5

2012 5