HANA Table Function

[Former Member]

Hello Team,

MY SAP HANA version is, 1.00.095.00.1429086950 (fa/newdb100_rel)

I have created a Table Function which I want to join it to the fact table in calculation view, but unfortunately its not allowing me to drag the function in Join node of Calculation View. I tried with Project as well but no sucess.

Am I going wrong anywhere?

My SAP HANA Studio version is Version: 2.1.16

Thank You,

Amol

[rindia]

Hi Amol,

First create table function from existing sqlscript calculation view using option "Save as".

(How to do: refer to page 62 of SPS 09 Modeling guide).

Once you have this table function, then try drag and drop this table function into graphical calculation view.

Let us know after you try this.

Good luck.

Raj

[rindia]

Table functions can be used in calculation views in HANA Studio development perspective (from SPS 09 onwards). I guess you are doing this in Modeler perspective.

[Former Member]

Hello Raj,

Thank you for the inputs but evenif I am in development prospective, still I am not able to do it.

Please find the screenshot.

Thank You,

Amol

[Former Member]

Hello Team,

Any updates on this?

Thank You,

Amol

[Former Member]

Hello Lars/Lucas,

Any suggestions?

Thank You,

Amol