0

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 trying to use table functions, just something simple for starters (i.e no params in, table out).

The table:

enter image description here enter image description here

The function:

enter image description here

The Calc view: (type dimension)
enter image description here

The error (on activation of the dimension calc view):
enter image description here

The function itself seems to be fine, i.e. it returns data when I call it from SQL:
enter image description here

mitch_au
  • 323
  • 1
  • 2
  • 9

2 Answers2

0

Please use the "Web based Development Workbench" or the "WebIDE" for this modelling. If I remember correctly, the HANA studio does not support table functions as data source quite well.

Lars Br.
  • 9,949
  • 2
  • 15
  • 29
-1

We are using a scripted procedure in Calc view. This works fine for us.

Scripted procedures

Kumar Attangudi Perichiappan
  • 26
  • 3