Non mandatory parameter in SQL scripted hana view

[#1]

Hi,

I created calculation view of SQL Script type. For this view I'm trying to create input parameter which is not mandatory. When I uncheck Is Mandatory option and try to click OK, I'm getting error message:   Specify a default value for the input parameter

Even if I select some value from the list as default value the message still occurs until I select Is Mandatory option again. So no matter if the default value remains empty or I put some value - the error message appears.

This problem occurs only in SQL Script Calculation View, for graphical one it is fine.

Could you please help me with this?

[KonradZaleski]

Anyway, I think that there is no possibility to leave the parameter value as blank, because when I execute data preview without setting the value, I'm getting error message:

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [34092] search on calculation model requires parameters;Required variable $$Parameter$$ is not set.

Possible Cause(s): The value for the input parameter used in a calculated column is missing

Proposed Solution(s): Either set the default value for the input parameter while creating it, or provide the value for the input parameter at runtime during data preview.