topic Re: Error in Direct Discovery script in QlikView

Error in Direct Discovery script

Thu, 23 Oct 2014 20:53:35 GMT

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"
;

Re: Error in Direct Discovery script

agomes1971 — Fri, 31 Oct 2014 15:49:11 GMT

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é

Re: Error in Direct Discovery script

agomes1971 — Mon, 03 Nov 2014 16:34:59 GMT

Hi again

put the cast inside native('')

please feel free to ask more things.

Regards

André