BusinessObjects Universe Design Tool: Each calculated column must have an explicit name

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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *