Skip to Content
0
Former Member
Apr 09, 2013 at 01:24 PM

Error "invalid use of an aggregate function" while refreshing WEBI on Syabse IQ 15.4 datasource

197 Views

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.

Attachments

WEBI_Error.jpg (38.0 kB)