Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 31, 2017 at 08:02 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03, 2017 at 10:01 PM

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

    Add comment
    10|10000 characters needed characters exceeded