Non mandatory parameter in SQL scripted hana view

[KonradZaleski]

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 · Accepted solution]

This problem occurs in Version of HANA Studio 2.2.13. I checked the same view in HANA Studio 2.0.20 and I'm able to create non mandatory input parameter.

So this is a bug in Version 2.2.13

[lbreddemann · Accepted solution]

Sounds like you may be right about this being a SAP HANA Studio bug.

Seeing that it affects an older than current version, the obvious way to avoid it is to upgrade to the current SAP HANA studio revision. You could also avoid the Studio for modelling and use the Web based modelling tools instead.

[former_member585404 · Accepted solution]

Hi,

We too are facing the same issue in scripted calculation views.

If you want to create a non mandatory parameter. Create a parameter(Mandatory) and change it in the properties of the parameter ( Is mandatory = False).

[lbreddemann · Accepted solution]

All good and nice. In case you're actually using the current version of SAP HANA studio, your option to report this bug is to open a support incident.

Other than that, "we have that same problem" posts don't really move things ahead.

[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.