Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 18, 2017 at 03:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded