Question Re: Non mandatory parameter in SQL scripted hana view in Technology Q&A

Non mandatory parameter in SQL scripted hana view

KonradZaleski — Thu, 28 Jul 2016 14:08:31 GMT

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?

Re: Non mandatory parameter in SQL scripted hana view

KonradZaleski — Thu, 28 Jul 2016 15:35:10 GMT

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

Re: Non mandatory parameter in SQL scripted hana view

lbreddemann — Fri, 29 Jul 2016 00:12:45 GMT

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.

Re: Non mandatory parameter in SQL scripted hana view

Former Member — Fri, 29 Jul 2016 05:16:11 GMT

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

Re: Non mandatory parameter in SQL scripted hana view

lbreddemann — Fri, 29 Jul 2016 05:33:04 GMT

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.

Re: Non mandatory parameter in SQL scripted hana view

KonradZaleski — Wed, 03 Aug 2016 15:41:39 GMT

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.