Getting error while passing multiple entries input parameter to calculation view in HANA Cloud.

[former_member857322]

Hi All,

I'm trying to pass multiple entries for input parameter IP_FIN_REG with multiple entries enabled and I'm filtering parameter using this expression.

"FinRegionKey"=$$IP_FIN_REG$$

While I'm trying to pass the multiple entries getting this error

Whereas it works while passing single entry, throws error when passing multiple entries. Anyone please let me know how to fix this.

Kind regards,

Chethan

[former_member42822]

Can you try the below

in("FinRegionKey",$$IP_FIN_REG$$)

[former_member857322]

Hi Vinoth,

Thanks for the quick response. I tried that, getting invalid expression error. Also, FYI, I'm developing calculation views in Business Application Studio.

[former_member42822]

Hello Chethan,

There is a small change in BAS. This works

"FinRegionKey" in ($$IP_FIN_REG$$)

You can refer the syntax here

https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-modeling-guide-for-sa...

[former_member857322]

Thank you so much Vinoth, It worked!