Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    Regards,

    Nag

    Add comment
    10|10000 characters needed characters exceeded