Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Aug 28, 2017 at 03:13 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.