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.
Support for OLAP functions is a rapidly evolving area of Sybase product development.