Skip to Content
0

HANA Modeling: Table function in Join node is not fetching data

May 10, 2017 at 04:27 PM

102

avatar image

Dear SCN Members, @lars.breddemann,

I have created a table function which fetches the data from 0 to 23 as Hours i.e., using a Time series in sqlscript as follows:

FUNCTION "SCHEMA_A"."TF_TRIP_HOURS"()
RETURNS TABLE("TRIP_HOURS" Integer,"DUMMY_MEASURE" Integer)
AS
BEGIN
/* Gives the Hours in a day (0 to 23) */
RETURN SELECT "GENERATED_PERIOD_START" "TRIP_HOURS",1 AS "DUMMY_MEASURE" 
FROM SERIES_GENERATE_INTEGER(1, 0, 24);                      
END

I have used as a Cross Joined with the other projection where I have used other view, but the data fails at Join node. The environment of HANA is SPS 10 (v 1.00.36)

Cross Join in Join_1 node as follows:

If I execute a SELECT COUNT(*) FROM VIEW which has TF gets zero count.

And the interesting part is it is working fine in the environment which is SPS 12 (v 1.120.16)

If I execute a SELECT COUNT(*) FROM VIEW which has TF gets non-zero count.

Please suggest if the above operation is because of version or SP issue or it is due to modelling issue on TF design since I could not find the valid SAP Note on the above case.

I did a refer on the following threads though:

https://blogs.sap.com/2012/12/07/table-user-defined-functions-table-udf-in-hana/

https://archive.sap.com/discussions/thread/3719506

https://archive.sap.com/discussions/thread/3719302

Best Regards,

Nachappa S

view-1.png (17.9 kB)
cross-join.png (39.4 kB)
10 |10000 characters needed characters left characters exceeded

Dear SCN Members,

Please suggest if anybody encountered similar issues with respect to User defined Table function in HANA.

Thanks in advance.

Nachappa S

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Nachappa S May 15, 2017 at 03:42 PM
0

It was an service pack issue. Issue resolved after the upgrade to SPS12.

Thanks,

Nachappa S

Share
10 |10000 characters needed characters left characters exceeded