Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
;
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é
Hi again
put the cast inside native('')
please feel free to ask more things.
Regards
André