This content has been marked as final. Show 5 replies
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:-
TO_DOUBLE(MON) AS MONTH1,
RACCT AS Account_Number
TO_DOUBLE(AMOUNT) as AMOUNT,
TO_DOUBLE(PAMOUNT) as PAMOUNT
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:-
Please help me in resolving this issue; This is totally screwing my efforts in HANA-QlikView integration POC in our organisation.
Thanks in advance,