Calculated column using SQL function gives unregistered function error

[Former Member]

Hello All,

I am trying to use SQL functions, esp (WEEK(date)) in a calculated column and am faced with the error

"Invalid Expression SAP DBTech JDBC [2048]: column store error : Unregistered function name : week"

The same function in an SQL statement works

Can you let me know if I am missing something?

Thanks and Regards,

Vijay

[Former Member]

Hi Vijay,

WEEK() function is not supported in calculated column, it is an SQL window function.

Regards,

Chandra.