The following are the functions that the SAP HANA connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Not all functions are available for multidimensional data.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
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.
Custom queries for multidimensional data
Custom queries are supported for SAP HANA multidimensional data.
Note: You must know how to construct queries for your multidimensional data.
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