Is it possible to insert/update data into a HANA view through xsjs?

[Former Member]

I have successfully exposed a flat HANA table through xsjs and I am able to delete and update records.

My question is, would it be possible on top of a view? (such as analytical view)

[jyoti_senapati]

Hi Wayne,

You cant do data manipulations like Update,Insert or delete inside Analytical, Attribute or Calculation View. But if you want to hide data you can use projection or filters.

Regards,

Jyoti

[pfefferf]

Hello Wayne,

create/update/delete on e.g. analytical views is not possible directly.

If you expose a view via an OData service an indirect create/update/delete is possible using XSJS and SQLScript OData Exits (in the exits the underlying tables can be updated).

Depending on the specific scenario this makes sometimes sense and sometimes not.

Best Regards,

Florian