SAP HANA 1.x

The tables listed below describe the MicroStrategy function support for SAP HANA 1.x databases:

SAP HANA 1.0 SP4

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Greatest Least Max Min Multiply Stdev Sum Var
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC
Null and Zero functions	NullToZero ZeroToNull
OLAP functions	None
Rank and NTile functions	None
String functions	None
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With NotIn NotLike
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Round Round2 Sin Sinh Sqrt Tan Tanh Trunc
Statistical functions	None

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Greatest Least Max Min Multiply Stdev Sum Var
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC
Null and Zero functions	NullToZero ZeroToNull
OLAP functions	Lag Lead OLAPRank
Rank and NTile functions	None
String functions	None
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With NotIn NotLike
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Round Round2 Sin Sinh Sqrt Tan Tanh Trunc
Statistical functions	None