Skip to Content

Use UDF table function as data source in calculation view

Oct 09, 2017 at 12:56 AM


avatar image

Hi everyone,

I'm wondering if someone can help me decipher this Hana Studio Error. I'm very new to this, so apologies if this is just me being simple. I'm running HANA express 2.0 sps1.

I'm trying to use a table function as a data source in a projection node.

Here's the table:

Here's my simple UDF function:

This function works if I call it from the SQL Console:

I can't get it to work in my graphical calc view though...

The view

The error:

The error seems to suggest that I haven't mapped something, but as I understand it you only need to map importing params into a function; in this case I don't have any.

Can anyone point me in the right direction?

1.png (19.3 kB)
2.png (14.9 kB)
f.png (25.8 kB)
3.png (15.2 kB)
4.png (35.5 kB)
5.png (23.2 kB)
6.png (112.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Xuelian Song
Oct 13, 2017 at 04:25 PM

Contacted the Calc view team, here is their response: "We cannot reproduce this problem. In the screenshot, I can see that the column names in the calc view are in lower case although they are defined in upper case in the table function. In modeler, I cannot reproduce this state. As soon as I add the table function to the calc view, the column names are taken correctly as defined in the table function. It would be interesting to know how the calc view is created and whether or not the column names have been changed by the user after adding the table function to the calc view."

10 |10000 characters needed characters left characters exceeded