Input parameter pass multiple entries to calculated column

[Former Member]

Can any one please guide on how to pass the multiple entries enabled input parameter to the calculated measure? I am not able  to do
so.

Example below-

Calculated measure

QTY_UNALLOCATED_NA

Formula

if("MP_WERKS"='$$PAR_WERKS1_NA$$',QTY_UNALLOC,0)

Input Parameter
'$$PAR_WERKS1_NA$$' is defined as Parameter Type column.

Reference col:
MP_WERKS (field)

So when I pass"Plant1" in the input parameters #$$PAR_WERKS1_NA$$' I get data.

When I pass  "Plant1","Plant2"(multiple entries) #$$PAR_WERKS1_NA$$' I do not get data.

Can you please please guide, this is urgent for us.

[RashmiAcharya]

Hi Pallavi,

If you are in HANA SP8 version you can try with the above link given by Sreehari.

If you are in HANA SP9 version and you have created the input parameter with 'Multiple Entries' (new option available in SP9) then try giving below formula in your calculated measure,

if(in("MP_WERKS",'$$PAR_WERKS1_NA$$')=1,QTY_UNALLOC,0)

Regards,

Rashmi

[Former Member]

hi..

Thankyou for responding. I do not get any errors but when I run the report I get no applicable data.

can you please again and let me know if I am missing anything?

below my input parameter and definition. I am sure I have data for the plants I give input,

output is wrong as no applicable data

[sreehari_vpillai]

Hi,

Pass the data like below and try.

0001','6000','6100','6200','6300','1000','5000

sree

[Former Member]

did you get a chance to look into this?

[RashmiAcharya]

Hi Pallavi,

Can you try removing the quotes around parameter in formula?

Like below,

if(in("MP_WERKS",$$PAR_WERKS1_NA$$)=1,"QTY_UNALLOC",0)

Regards,

Rashmi

[Former Member]

no its not. can you try in your system please? and let me know..its a request

[Former Member]

we are on SP09

[RashmiAcharya]

Hi Pallavi,

I tried in SP9, with same scenario and in modeler data preview I am getting correct data.

Did you try to do data preview in modeler?

Regards,

Rashmi

[Former Member]

thanks for trying..do you mind copying the dummy formula for me..?

also the way you are passing the number? Please., may be I am doing some mistake.

[RashmiAcharya]

Hi Pallavi,

Formula in calcuated column:

Multiple values given for parameter at runtime:

Data preview results:

Regards,

Rashmi

[sreehari_vpillai]

Hi Pallavi,

Go through this nice document by Krishna.

Sreehari