IQ currently supports these OLAP functions: Grouping(), Variance(), StdDev(), Rank(), Dense_Rank(), Percentile_Disc(), Percentile_Cont(), Ntile().
Adaptive Server Anywhere supports all of the IQ OLAP functions, plus Corr(), Covar_Pop(), Covar_Samp(), Cume_Dist, Percent_Rank(), Regr_Avgx(), Regr_Avgy(), Regr_Intercept(), Regr_Slope(), Regr_Sxx(), Regr_Sxy(), Regr_Syy(), Stddev_Pop, Stddev_Samp (Stddev is alias), Var_Pop, and Var_Samp (Variance is alias).
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.
