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

  • Hello Upamanyu,

    Kindly please share the solution,

    Thanks

    Ravi

  • Hi Ravi,

    I had implemented this using a table function on a graphical view and finally consuming this table function in another graphical view. Below lines explain how to map the input parameters from the table function to the base view-

    VAR1 = SELECT ...

    FROM <VIEW>

    ( PLACEHOLDER."$VIEW_IP1$"=> :TABLE_FUNCTION_IP1,

    PLACEHOLDER."$VIEW_IP2$"=> ::TABLE_FUNCTION_IP2)

    Now you can build the rest of the logic using VAR1 and so on.

    Finally this table function will be consumed in a graphical view where the parameters can be mapped from the view to the table function using manage mapping. Hope this helps.

  • 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