Question Re: Problems while using Multiple Entry Input Parameters in HANA Graphical calculation view in Technology Q&A

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

Former Member — Thu, 23 Mar 2017 20:05:27 GMT

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

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

sap_cohort — Tue, 16 Jan 2018 15:36:17 GMT

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.

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

Former Member — Wed, 28 Aug 2019 18:02:07 GMT

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.)