We are being strict about the notion of an unrelated order by key. If the group by were not there, then the query would resolve just fine. It wouldn't be a problem though to loosen that restriction for cases like this where the column reference also being projected. I can log a JIRA.
There is no expectation though for the alias to be resolvable in the group by clause. Is Mondrian also generating queries of that form?
thats good to know... the alias in the order by isn't important. I just wondered why it worked with the alias but not with the table.column.
Unfortunately Mondrian only generates queries with group by "table"."column" order by "table"."column" so right now I can't use Mondrian for OLAP with the vdb.
I would be thankful if you can log a JIRA.