I have few WEBI reports which are working very well in my test environment on BO XI 3.1 SP3 FP3.5 with Sybase IQ 15.1 as data source. When I moved these reports to production where we have Sybase IQ 15.4 as data source, I am getting error "[Sybase][ODBC Driver][Sybase IQ] " Invalid use of an aggregate function" (WIS 10901)". (attached)
In my report I have used functions like STDDEV, AVERAGE, SUM. COVAR_SAMP etc which I have activated in asiq and asiqen .prm files. I am not able to reach conclusion as what is causing this error.
Quick help will be a great relief as we are overdue to go live.