Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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 ?
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.
Hi,
we are using same thing but we want Placeholder type functionality to improve performance of Direct Discovery query.
Thanks for u r advice.