Skip to Content
0
Former Member
Jun 02, 2016 at 04:10 AM

Map Stored Procedure to Calc View Input Parameter

599 Views

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

Attachments

SP OUTPUT.JPG (13.1 kB)
SP PROMPT.JPG (40.9 kB)
SP_MAX_DATE.JPG (31.4 kB)