Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error in Direct Discovery script

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

DD Error.png

2 Replies
agomes1971
Valued Contributor

Re: Error in Direct Discovery script

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
Valued Contributor

Re: Error in Direct Discovery script

Hi again

put the cast inside native('')

please feel free to ask more things.

Regards

André

Community Browser