I've used Universe Design tools to build a FinTrade universe which is connected to Sybase IQ 15.x using ODBC. I then use Information Design Tools to convert it to a unx format universe.
However, the query failed with the following error :
The query cannot run because it contains incompatible objects. (WIS 00008)
I've tried to drag one column, and I found that view the scripts as below, with double quotes. If I remove all the double quotes and use the 'custom SQL', it could be validate. However, if I drag more than 2 columns, I was not able to use 'custom SQL'.
Any configuration I could set to remove all the quotes?
SELECT
"DIM_INSTR"."INSTR_NAME"
FROM
"DIM_INSTR"