Date and Time functions
YEAR, QUARTER, MONTH, MONTHNAME, WEEK, DAYOFWEEK, DAYOFYEAR, DAYOFMONTH, DAYNAME, HOUR, MINUTE, SECOND, MILLISECOND, NOW, ADD_DAYS, ADD_MONTHS, ADD_SECONDS, ADD_YEARS, ISOWEEK, NEXT_DAY, LAST_DAY, YEARS_BETWEEN, MONTHS_BETWEEN, DAYS_BETWEEN, SECONDS_BETWEEN, LOCALTOUTC, UTCTOLOCAL
Conversion functions
SN
Operators
%, -, +, *, /
Text functions
ASCII, CHAR, CONCAT, LCASE, UCASE, LOWER, UPPER, LEFT, RIGHT, LENGTH, LOCATE, LPAD, RPAD, TRIM, LTRIM, RTRIM, NCHAR, REPLACE, SUBSTR_AFTER, SUBSTR_BEFORE, SUBSTRING, UNICODE
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT
Statistical functions only available for relational data:
MEDIAN, STDDEV, STDDEV_POP, STDDEV_SAMP, VAR, VAR_POP, VAR_SAMP
Math functions
Note: Math functions are only available for relational SAP HANA data, and cannot be used for information views data.
ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, BITCOUNT, CEIL, COS, COSH, COT, EXP , FLOOR, LN, LOG, MOD, POWER, ROUND, SIGN, SIN, SINH, SQRT, TAN, TANH, UMINUS
Miscellaneous functions
WIDTH_BUCKET
Other functionality
Binning
Binning is supported.
For binning, use the function WIDTH_BUCKET (see the official SAP HANA documentation from SAP).
You can also use the Spotfire function BinByEvenIntervals.
Stored procedures
Stored procedures are available only for relational data.
Data from stored procedures in SAP HANA can only be imported. The External load method (in-database) is not available.
Non-supported functions
Math functions:
GREATEST, LEAST, HEXTOBIN, BINTOHEX.
Date and Time functions:
CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_UTCDATE, CURRENT_UTCTIME, CURRENT_UTCTIMESTAMP, EXTRACT