Multiple "input parameters" in SAP HANA in a standard way

[former_member208413]

Hello,

I have read an article named "Using Multiple Values in Input parameter for filtering in Graphical Calculation View", but I have problems with calculations view that call analytic view with input parameters.

Since the article explains a non-standard method, is there any way to do this in a standard way? Will be this functionality standard-available in the next versions of SAP HANA?

Best regards.

[ChengJiajia]

Hello Expert,

I already have my HANA Database on SP09- rev 1.00.100.00.

However, when I use my input parameter as Multiple Entries, I still did not get the multiple value input working.

I tried below filter expression

Option1   =>    in("CARRID",'$$P_CARRID$$') 

Option 2  =>    "CARRID" = '$$P_CARRID$$'

But either option returns the expected result.

I use below input screens for multiple value input.
But they either return the 0 records or return with error, not the result set contain both CARRID = SQ or CARRID = LH as I expected.

or below input screen

What would be the right way to get result from multiple input parameter in SP09 ?
Thanks a lot for your kindly help.

[pfefferf]

Hello,

define your filter expression like following:

in("CARRID", $$P_CARRID$$)

=> the parameter must not be enclosed in quotes

Regarding the input:

Your second option is correct. For every value an own line has to be entered with a single value.

If you do not get a result then, please check your view settings (e.g. you have set session client as default client, you will not get a result if no session client is set for your user).

Best Regards,

Florian

[ChengJiajia]

Hello Florian,

Remove the single quote works fine for my HANA model.

I will double check whether the front-end tool can accept this multiple input.

Thanks a lot for the kindly help.  

[former_member182302]

Hi ,

If you are on lower version than SP09.

Have a look on this thread as well

Regards,

Krishna Tangudu

[pfefferf]

Hello,

multi-value input parameters are supported since SPS09.

You can refer on chapter 8.4 in the Modeling Reference Guide (http://help.sap.com/hana/SAP_HANA_Modeling_Guide_for_SAP_HANA_Studio_en.pdf) or slide 8 in presentation SAP HANA SPS09 - HANA Modeling.

Best Regards,

Florian