Skip to Content
author's profile photo Former Member
Former Member

HDI SPS12: hdbtablefunction in not present for my calculation view

hello

on HANA SPS12

i am trying to use a table function, formally know as hdbtablefunction, in an HDI calculation view.

i can create my table function ok, and it saves it as a hdbfunction.

then when i try to find it as a source, it is not there, probably because the extension is no longer hdbtablefunction.

so, what to do

thanks

update: i have put

/src/TABLE_FUNC_SCALE.hdbfunction


at the top of the file , and still did not work

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jul 28, 2016 at 12:32 AM

    you can find that in your HANA Runtime tool--> Containers--> Table function in Function folder.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2016 at 12:26 PM

    without documentation, to create a manual hdbtablfunction, i had to hacking into the .hdiconfig file and add

    "hdbtablefunction": {

    "plugin_name": "com.sap.hana.di.function",

    "plugin_version": "12.1.0"

    },

    this enabled me to manually create a new file, with the extension .hdbtablefunction, which i thought was looking like it would work, but unfortunately, when i got around to the calculation view, it still would not see the function as a possible source

    i must be missing something!

    anyone ?

    ta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2016 at 09:17 AM

    anyone ever managed to do this ?

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes I've done this just fine. Its normal that the table function won't show up in the data source search if you've not done a build on the HDB module in order to generate the runtime objects in the container. But otherwise I've got several examples and exercises where I use table functions as sources in graphical calculation views and they work just fine.

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.