XSOdata accessing Table Function in the calculation view

[Former Member]

Hello Friends

I am new to SAP HANA world.

We have built a calculation view, which uses a table returned by a table function. Table function uses WORKDAYS_BETWEEN, for calculating the working days between two dates.

Now, this calculation view is being exposed via XSODATA. We are getting an error, when calling this oData service. "remote query execution failure: could not read working days information from table TFACS "DEV_LTD"."TFACS" - at ptime/session/dist/RemoteQueryExecution.cc:234"

Has anyone come across such a similar situation? The calc view without this table function is being exposed without any issues.

Thanks for your inputs/suggestions for a break through of this error

Regards/Sudhakar

[pfefferf]

So what is the issue here? As according to your description the table function does not work and a proper error message is provided you just have to fix this. As mentioned in the documentation for the WORKDAYS_BETWEEN function, you need the factory calendar table TFACS. As it seems you do not have provided it in your schema.

Regards,
Florian