Skip to Content

Can we expose a calculation view with Multi-value input parameters as an XSOdata service?

Apr 11 at 08:51 AM


avatar image

I have a calculation view that has 2 input parameters. One of them is a multi-value input parameter. I tried using it as an XSOdata service but could not. the XSodata file would refuse to activate stating an error that columns were not found. After making the input parameter as a single-value parameter, the xsodata service could be activated.

So, I wanted to know if having a multi-value input parameter as an xsodata service is possible. If yes, can someone share the details or syntax for this?

Thank you.

PS: We have a HANA instance with SPS 10. Please let me know if you need more details.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagaraj G Apr 17 at 09:56 PM

Hi Joel,

I tried below workaround which worked for me.

1. Create input parameter( say ip_test) with singe selection

2. Apply projection filter using IN operator. I.e. In (ip_test,column_name)

3. while calling OData, pass the values to input parameter as: ('PLACEHOLDER' = ('$$ip_test$$', '''ab'',''xy''') )

Please check this blog for more details



10 |10000 characters needed characters left characters exceeded