HDI SPS12: hdbtablefunction in not present for my calculation view

[Former Member]

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

[Former Member]

anyone ever managed to do this ?

[thomas_jung]

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.

[Former Member]

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

[chandan_praharaj]

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

[Former Member]

see from the above image, on the left side is my tablefunction, but it does not have the tablefunction extension. because of that, i think the source for the calculation view, cannot see the function "footprint"