Multiple parameters in Calculation script view

[gokul_jayaraman2]

Hi All,

We just upgraded to SPS 11.

I created an input parameters with Multiple entries. I used the Parameter IP_MATNR in the select query

var_out = select matnr,werks from XYZ.MARC where matnr = :IP_MATNR

When i run the data preview and gave the value for IP_MATNR = 'PART123' , I get error like shown below

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$ip_matnr$$. Variable is marked as required but not set in the query

This worked fine when i removed multiple parameter option.

Please let me know if i am passing the parameter right or am i missing something ?

Thanks,

Gokul

[pfefferf · Accepted solution]

Hello Gokul,

blog describes in detail how you can solve your issue (with some background information).

Regards,

Florian