Is it possible to do a data validation in Input Parameters for a Calculation View?

[Former Member]

Hi All,

Can we put some sort of data validation on the input parameters in SAP HANA calculation views? I know it is possible to get a value help created using reference columns from external tables/views but that does not stop me from providing a non-existent value in the input screen.

Can this sort of validation be done preventing the user from entering values that do not exist in the view?

Regards,

Shyam

[BenedictV]

How about if you un-check the 'Input Enabled' checkbox when defining the parameter. This would prevent the user from overriding any values.

[k_gorin]

I guess you could script it with SQL and raise errors.