Question Re: Create a Calculation view that reads a table function as data source in Technology Q&A

Create a Calculation view that reads a table function as data source

former_member507304 — Thu, 22 Feb 2018 09:34:04 GMT

Hi experts.

I'm building a test calculation view that reads from a table function:

create function "tableFunction" ()
Returns table ( "nu1" integer, "na" NVARCHAR(35), "nu2" integer)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
BEGIN
RETURN
SELECT "E_ID" as "nu1", "E_NAME" AS "na", "E_OVERTIME" as "nu2" FROM "OVERTIME";
END;

The fact is that the function works fine and it returns that test table, but i have a problem when i try to read it in the calc view:

Could you help me to solve this error or if it is not possible to do this. How could I read from a procedure or something that allows me to clean data before load it on hana?

Thanks in advance.

Re: Create a Calculation view that reads a table function as data source

lbreddemann — Thu, 22 Feb 2018 10:38:30 GMT

Use a table function that was defined as a repository object.

Re: Create a Calculation view that reads a table function as data source

former_member507304 — Thu, 22 Feb 2018 12:18:14 GMT

Please could you tell me how do i do this or where can i see documentation about it ?

Re: Create a Calculation view that reads a table function as data source

lbreddemann — Fri, 23 Feb 2018 00:29:40 GMT

Checked the developer guides?

Re: Create a Calculation view that reads a table function as data source

former_member507304 — Wed, 28 Feb 2018 11:50:01 GMT

I think that not, could you indicate what are the guides for this issue of table functions? One friend told me about define a table structure and return it in instead of the table. I will chek it as soon as I will have time.

Re: Create a Calculation view that reads a table function as data source

lbreddemann — Wed, 28 Feb 2018 20:40:45 GMT

https://help.sap.com has got the whole HANA documentation including all developer guides.

Once you got the time, just use your google skills to find the specific topic.

Re: Create a Calculation view that reads a table function as data source

former_member507304 — Fri, 23 Mar 2018 13:45:53 GMT

Finally was that, a lot of thanks