Currently, Adaptive Server Enterprise does not support OLAP functions. Sybase IQ and SQL Anywhere do.
Corr()
Covar_Pop()
Covar_Samp()
Cume_Dist
Dense_Rank()
Exp_Weighted_Avg
First_Value
Last_Value
Median
Ntile()
Percent_Rank()
Percentile_Cont()
Percentile_Disc()
Rank()
Regr_Avgx()
Regr_Avgy()
Regr_Intercept()
Regr_R2
Regr_Slope()
Regr_Sxx()
Regr_Sxy()
Regr_Syy()
StdDev()
Stddev_Pop
Stddev_Samp
Var_Pop
Var_Samp
Variance()
Weighted_Avg
SQL Anywhere supports all of the Sybase IQ OLAP functions.
Currently, Adaptive Server Enterprise does not support OLAP functions.
CIS functional compensation does not support OLAP functions.