Problems while using Multiple Entry Input Parameters in HANA Graphical calculation view

[Former Member]

Hi!

I'm working with input parameters in graphical calculation views. So far, I've been using single value inputs and works perfectly, but now I need the view to be able to filter from a list of values.

At first, I just checked the "Multiple entries" box in the input parameter, hoping it would be that simple, but it isn't. I've tried many ways and I keep getting the same error, everytime.

I've changed the filtering expression to make sure it filters correctly, but I still get this error:

Error: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306002: An internal error occurred

Has anybody experienced something like this? Am I missing something?

Thank you in advance for your replies!

Juan

[Former Member]

In HANA I am able to fix it.

One single value input parameter and 2nd multiple entry input parameter.

In Projection node, in Filter expression you just add expression like below:

(Comment_IP is single value mandatory variable and ARE_IP is multiple entry non mandatory variable) I am able to get correct data with this expression.

"Comment" = '$$Comment_IP$$'

AND

(in ("ARE" , $$ARE_IP$$) or match("ARE", $$ARE_IP$$))

(Dont give ' ' in above in expression for input parameters.)

[sap_cohort]

Hi, Have you figured out what is causing this issue? I just ran into the same exact issue and it makes no sense.

THanks for any help.