cancel
Showing results for 
Search instead for 
Did you mean: 

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

joel_john1
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member213277
Active Participant
0 Kudos

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

Regards,

Nag