In SAP BusinessObjects Universe Design Tool, you might get the following error – “Each calculated column must have an explicit name”.
Each 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 it’s alias. So that query should be re-written as:
select to_char(statusdate, 'DD-MMM-YYYY') as datetext from person