Skip to Content
0

How to pass multiple values in input parameter in scripted calculation views in HANA (SP12)

Apr 18, 2017 at 12:58 PM

1.4k

avatar image
Former Member

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

ip-settings.jpg (75.4 kB)
table-data.jpg (15.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Apr 18, 2017 at 03:25 PM
0

Hello Upamanyu,

the topic was discussed here already several times (check the results of the search). I think the best answer you can find here is available in post On multiple mistakes with IN conditions.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded