2 Replies Latest reply: Nov 3, 2014 11:35 AM by André Gomes RSS

    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