Error in Direct Discovery script

[#1]

I am prototyping Direct Discovery against an SAP Hana database.  If I do a standard SQL Select, I get the data, however, when I use Direct Query with the following script, I get an error.  The syntax looks correct according to the most recent documentation.  Any thoughts?

ODBC CONNECT TO [IQ5 ODBC_USER] (XUserId is OKbRdHRICaQeVKNKFSUSM, XPassword is PcfUGKBGNLYIHYEGBBQB);

//SQL SELECT
DIRECT QUERY
DIMENSION
  PRODORDER,
MEASURE
  cast("/BIC/ZLABOR1" as double) as "IE Labor Value_/BIC/ZLABOR1",
  cast("/BIC/ZLABOR2" as double) as "Earned Labor_/BIC/ZLABOR2"
FROM
SAPIQ5."/BIC/AZPP_O5700"
;

[agomes1971]

Hi,

Greg,

Direct Discovery do not admit standard sql.

The best thing to do its to use a View with your standard query.

Any doubts you're quite welcome.

André

[agomes1971]

Hi again

put the cast inside native('')

please feel free to ask more things.

Regards

André