In SAP BusinessObjects Universe Design Tool, you might get the following error – “Each calculated column must have an explicit name”.
Even though the query runs fine in the underlying database, but Universe Design Tool doesn’t accept it. The reason is it expects ‘AS’ keyword between the calculated column and its alias. So that query should be re-written as:
select to_char(statusdate, 'DD-MMM-YYYY') as datetext