5 Replies Latest reply: Mar 3, 2015 5:43 AM by Mukesh Chaudhari RSS

    HANA Direct Query with PLACEHOLDER error

      Hi,

       

      I am connecting to HANA DB View with Direct Discovery and able to fetch correct data from it. When I try to use PLACEHOLDER with my query; QlikView edit script shows wrong syntax error as well as reloading that code gives "Line is not valid" error.

      I am connecting HANA DB with ODBC driver. QV ver.11 SR10.

       

      Below is my query:-

       

      DIRECT QUERY

       

      DIMENSION

      TO_DOUBLE(MON) AS MONTH1,

      RYEAR,

      RBUKRS,

      PRCTR,

      RACCT AS Account_Number

      MEASURE

      TO_DOUBLE(AMOUNT) as AMOUNT,

      TO_DOUBLE(PAMOUNT) as PAMOUNT

      FROM

      "_SYS_BIC"."Finance_dev.View1/CL_TEST" ('PLACEHOLDER'=('$$IP_YEAR$$','2015'));

       

      Error:-

       

      Line is not valid.

       

      This is a syntax error near statement ('PLACEHOLDER'=('$$IP_YEAR$$','2015'));

      There is nowhere mentioned in any HANA-QV document on PLACEHOLDER syntax with Direct Query.

       

      /////////////////////////////////

       

      On the other hand, when I use simple SQL statement to HANA view with same placeholder; it works correctly.

      Below is the SQL Select to HANA view:-

       

      SQL

      SELECT *

      FROM

      "_SYS_BIC"."Finance_dev.Dinesh/CL_TEST" ('PLACEHOLDER'=('$$IP_YEAR$$','2015'));

       

      //////////////////////////////////

       

      Please help me in resolving this issue; This is totally screwing my efforts in HANA-QlikView integration POC in our organisation.

       

      Thanks in advance,

      Parag.