Hi ,

I have a scenario where I need to pass multiple values to filter some data having varchar datatype using input parameter in a scripted calculation view.

I am using HANA SPS12 system.

ip-settings.jpg

I have attached a screenshot showing the input parameter configuration as well as the underlying table data.table-data.jpg

Sample code:

/********* Begin Procedure Script ************/

BEGIN

var_out = select * from "Schema"."ZPARAMTEST" where ID in (:IP_id);

END

/********* End Procedure Script ************/

I am not getting any data in the output on doing data preview even on passing valid inputs.

The generated query is :

SELECT TOP 200 "ID", max("VAL") AS "VAL"

FROM "_SYS_BIC"."dev/ZCVT"('PLACEHOLDER' = ('$$IP_ID$$', '''1'',''2'''))

GROUP BY "ID"

Is this option applicable only for graphical calculation views?

Is there any way to make this work in scripted views?

Eagerly waiting for any help...Thanks in advance!!!

Best regards,

Upamanyu Mukherjee