In HANA SP12, there is a new feature that HANA Scripted views can be replaced by table functions.
I migrated one of my script-based calculation view, and when I was trying to activate this migrated view, I met the error message:
Error reading table function TABLE_FUNCTION_XXX
I seached the SYS_BIC schema and could not find this table: TABLE_FUNCTION_XXX. (I think a corresponding table starting with TABLE_FUNCTION will be created under SYS_BIC schema, cause I see some other tables with similar name).
So my question is:
Is there any step I missed when I migrate the script-based view to table function?
Should I manually create TABLE_FUNCTION_XXX? Or this table will be created automatically during migration?
Thanks and best regards,
Found the solution.
After migrating script-based view to table function, a new object TABLE_FUNCTION_XXX.hdbtablefunction will be generated automatically and its initial status is inactive.
Need to activate this .hadtablefunction manually from repositories window, afterwards can activate the view successfully.