Skip to Content
0

Is it possible pass HANA Calculation View Columns to a "Table Function"

Aug 27, 2017 at 07:16 PM

99

avatar image

Does anybody knows whether is there any chance to pass "HANA Calculation View Columns" as "input Parameters" to a "Table Function" ?

What I need to do is the following; for every record from a Graphical Calculation view I need call a "Table Function" by sending certain paramters based on some Attributes belonging to the record from the Calculation View which is being processed.

Similar to the following link however, in my case I need get the Table Function input parameter from the content of certain Attributes belonging the record being processed:

https://blogs.sap.com/2017/05/26/playing-with-hana-parameters/

Thanks in advanced

Gustavo

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Aug 28, 2017 at 03:13 AM
0

Yes, with SAP HANA 2 SP01+ it is possible to model table functions as view nodes.

See the documentation on that.

With HANA 1 this is not possible (at least I haven't found a way to do that). There you probably will have to resort to a cursor loop in SQL Script.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Manay thanks Lars for your response !.

0