topic Re: HANA Direct Query with PLACEHOLDER error in Qlik Learning Discussions

HANA Direct Query with PLACEHOLDER error

Fri, 30 Jan 2015 05:33:04 GMT

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.

Re: HANA Direct Query with PLACEHOLDER error

mukesh24 — Thu, 19 Feb 2015 09:35:22 GMT

We r suffering above issue when we try QV on HANA with Direct Discovery.

Please Provide Solution ... If any 1 having idea about our question...

Regards,

Mukesh Chaudhari

Re: HANA Direct Query with PLACEHOLDER error

Caique_Zaniolo — Tue, 03 Mar 2015 10:07:51 GMT

This will only work if you are loading the table into QlilView. The direct discovery syntax will not support a placeholder and the script execution will fail.

The workaround is to solve these placeholders inside the calculation view using Hana's functions or use a where clause.

Re: HANA Direct Query with PLACEHOLDER error

mukesh24 — Tue, 03 Mar 2015 10:13:20 GMT

Hi Caique,

In Where clause we only Hard code value at time of load, but we want --> For example when user select company code value only that value should pass. How we will solve ?

Re: HANA Direct Query with PLACEHOLDER error

Caique_Zaniolo — Tue, 03 Mar 2015 10:32:40 GMT

Then you should add this field as a dimension on the direct query and let the used select in the UI.

DIrect discovery will will convert this as a where clause on the fly.

Re: HANA Direct Query with PLACEHOLDER error

mukesh24 — Tue, 03 Mar 2015 10:43:41 GMT

Hi,

we are using same thing but we want Placeholder type functionality to improve performance of Direct Discovery query.

Thanks for u r advice.