Any kind of aggregate functions are not working in JasperServer OLAP section. When i creating a aggregate table in my database is showing the error like this. The server has encountered an error. Please excuse the inconvenience. Error Message com.jaspersoft.jasperserver.api.JSException: mondrian.olap.MondrianException: Mondrian Error:Too many errors, '1', while loading/reloading aggregates. Error Trace com.jaspersoft.jasperserver.api.JSException: mondrian.olap.MondrianException: Mondrian Error:Too many errors, '1', while loading/reloading aggregates. at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeOlapModel(OlapConnectionServiceImpl.java:396) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) ............... ............ The Mondrian Error:Too many errors raise upto 1 to 10. How to i solve this problem and how to creating aggregate OLAP models ? and This is my OLAP cube simple aggregate definition : <Schema name="New Schema1"> <Cube name="New_vtf" cache="true" enabled="true"> <Table name="vt_fee" schema="public"> <AggName name="agg_yr_vt_fee"> <AggFactCount column="fact_count"/> <AggMeasure name="[measures].[fees_fine]" column="sum_fees_fine" /> <AggLevel name="[time].[year]" column="yr" /> </AggName> </Table> <----------- Rest of the Cube definition below ---------> Thanks, Post Edited by sdptamil at 13/03/2012 05:36 Post Edited by sdptamil at 13/03/2012 05:37