Optional Input Parameter with multiple values

[Former Member]

Hi,

We defined Optional input parameter with multiple values for a material in graphical calculation view

If we don't select any material in the filter then it should return all the materials or it should get only the materials if we enter  the material in the filter.

for this in the filter expression we are using the below syntax

in("MATNR",'$$IP_MATNR$$') or match ("MATNR",'*$$IP_MATNR$$*') .

With this expression we are getting syntax error.

Can any one help how to write filter expression for this requirement.

Thanks

Srini

[former_member182302 · Accepted solution]

Hi Srini,

That expression will work if you have used "Single Value" ( unchecked "multiple values" )..

If you need a expression to work with multiple values then you have to use like below :

in("MATNR",$$IP_MATNR$$) or match ("MATNR",$$IP_MATNR$$)

And then you can send '*' to get all values .

SELECT *
FROM "_SYS_BIC"."<CV_NAME>"('PLACEHOLDER' = ('$$IP_MATNR$$', '''*''')) 

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

Thanks for your response.

Case 1

Filter expression works if the input parameter settings are

1) Multiple Entries checked.

2) Parameter Type : Direct

I can execute the view in HANA studio and Analysis 2.2

Case 2

Filter expression with the below input parameter settings are not working

1) Multiple Entries checked.

2) Parameter Type : Column

I can execute the view in HANA studio but not in  Analysis 2.2, in Analysis it is throwing error.

Do we need any additional setting to make case 2 works in Analysis 2.2

[former_member182302 · Accepted solution]

Can you share the error message you are getting in Analsysi 2.2??

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

Below is the config for input parameter

Error in Analysis 2.2

[former_member182302 · Accepted solution]

have a look on the document and comments here

Regards,

Krishna Tangudu

[raghavendra_p · Accepted solution]

Hi Krishna,

Thank you for your time/response.

'Match' function is working fine with single input parameters, incase of multiple input parameters, if i use 'match' on all and if I pass value to one parameter and left another one blank, still system bringing all values.... ( Ideally, system should fetch data based on parameters entered only,.. just like BEx variables or any other variables)

ex - i have two parameters year and customer. If i pass customer value and left year as blank, system should fetch data for that customer for all years.