Multiple Values in Input Parameter - Hana Calculation view Analysis for Office

[kenton_burckhart]

I create d a graphical calculation view with multiple input parameters, one being a multi value input to filter on a projection. The Syntax of the filter is this: match("MDV01",'*$$ProdLine$$*') or in("MDV01",'$$ProdLine$$')

When i use analysis for office, the prompts display correctly giving multiple options

but i get the following error referencing TK_RPAREN missing.

[KonradZaleski · Accepted solution]

There are two issues which I see in your logic:

1. For your scenario you cannot use match function because it supports only single values.

2. For multi-value input parameter you should remove single quotes from filter expression :

in("MDV01",$$ProdLine$$)

[kenton_burckhart · Accepted solution]

Thanks Konrad. This helped me get it to work. The only issue i'm running into will be when its a parameter that we want to not be mandatory. I used the match() so that we could query all values of MDV01 if the prompt was left empty. Thanks for your help!

[shahidmahmud · Accepted solution]

Thanks, Konrad,

This is an old thread but the problem I was facing needed exactly this fix. Great work!

[raj_saptech]

Hi Konard,

I was able to figure out, each value should be in double quotes separated by a comma.

Thanks,

Raj

[raj_saptech]

Hi Konrad, In the above example the filter expression is good. However, if we need to pass the multiple values to the select queries using parameter i am getting an error. Could you Please advise.