Map Stored Procedure to Calc View Input Parameter

[Former Member]

Hi experts,

I am having trouble with a "Derived Procedure/Scalar Function" Input Parameter.

I believe the trouble is mapping my OUT Variable from the stored procedure to the Input Parameter on my Calculation View.

My Stored Procedure Selects the Max(Post_Date) from a transactions table, and I would like for that output to be the Default Value of the Input Parameter of my Model.

Per the HANA Modeling Guide SPS12 pg 121, it says I can do this

Both my Stored Procedure and Calc View have Activated successfully - however the default value is not there at RunTime. I am thinking I am not mapping correctly? Please help

                     

Output of Procedure Call

"From" does not display a default value like I wanted

[Former Member · Accepted solution]

Hi guys,

Just wanted to reply to this thread so anyone else having this issue can get help.

I got the procedure to work by defining it in "_SYS_BIC" .

Did not go through with any updates.

Previously I was attempting to define the Store Proc within my own Schema and also within a Package, but that was unsuccessful.

Good luck on your own attempts, here is my SP

[Former Member]

Florian, may I also ask what version of HANA DB you are on?

[pfefferf]

As mentioned above I tested it on an SPS10 system.

Regards,

Florian

[Former Member]

Hi yes, thanks Florian. It's pretty basic. I just specify "Derived From Procedure/Scalar Function" as the Parameter Type, then Specify the Stored Proc to Call.

Any thoughts?

[pfefferf]

Hm, looks ok. Tested it on a SPS10 system right now. Do you have the latest HANA tools installed?On your screenshot "Is Mandatory" is enabled, which must not be the case if "Derived from procedure option" is used. Maybe an indicator that an update is missing (in the latest version this issue is resolved).

Regards,

Florian

[Former Member]

I believe so but not positive. I am using Hana Studio 2.1.20 - which I think is SPS 12?

So "Is Mandatory" feature should not be there?

I do have "Input Enabled" checkbox marked

[pfefferf]

Do not mix up the Studio version with the DB version. These are two different things. The only dependency is that for newer DB versions you need also the updated Studio/HANA tools versions.

The latest HANA Studio/HANA tools version is 2.3.5.

A list which Studio version corresponds to which DB version can be found in note 2073112. Newer Studio versions are backwards compatible to "older" DB versions.

Regards,

Florian

[Former Member]

Okay thank you. I am having trouble with my S-ID password so wasn't able to view the note you shared.

However, I went to System>Properties>Version History and I believe the Hana DB version being used is 1.00.102.05.1455873859 is the latest update

[chandan_praharaj]

I have also tried to replicate the similar issue , and facing the same issue. Is it related to authorisation?

as I can call the SP from console and it is giving output

Sorry Florian can you please show how you are doing this with screen shot, if possible.

I am in SP10 and I think in SP10 we have this functionality enabled.

I think some tweak and we can achieve the outcome as desired. please help.

this concept is very important while dynamically selecting date range and stuff , which we can achieve in customer exit.

[Former Member]

I agree Chandran, dynamic default date range is how I had hoped to use this feature.

If Florian is able to get it to work with an updated HANA DB Version, then I know that is the issue.

I would be grateful if you would give it a try Florian and share a screenshot  .

If not, I suppose I'll have to try a scripted Calc View.

Thanks

[pfefferf]

Here are some screenshots (but not sure what they should help, there is nothing different to yours).

Procedure:

View Parameter Definition:

Defaulted Value:

[Former Member]

Thank you for sharing those, I found it helpful.

It must be as you said, due to an older DB Version.

[Former Member]

Am I missing something in my Stored Procedure Code?

[pfefferf]

Can you show us the parameter definition in the view?

Regards,

Florian