Skip to Content

Use UDF table function as data source in calculation view

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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."

    Add comment
    10|10000 characters needed characters exceeded