dprobst

Hello, I just want to precise that this query works well on JasperAnnalysis schema workbench, the problem that I've described is on JasperServer . (It is exactly the same error that one member has posted on the forum)

Hi, One topic has been wrote about this message error, while executing the query: select {([Annee].[All Annee].Children * [Measures].AllMembers )} ON COLUMNS, Hierarchize([uH].[All UH].Children) ON ROWS from [CubeTest] In my opinion, and after reading the same error message I deduced that there is a bug with the AllMembers function. The solution is to avoid this way of querying by writing the measures I want, but I don't know how to make this query. In my schema, I have 2 measures that are "TailleFS" and "OccupationFS" and i'd like to cross them with the Time dimension = [Annee].[All Annee].Children. [2008, 2009]*[OccupationFS, TAilleFS] in column --> 2008 TailleFS , 2008 OccupationFS, 2009 TailleFS, 2009 OccupationFS I join my logical schema which can help you to understand. "KP10" Thank you. Code:Error Trace: java.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)Vjava.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)V at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:269) at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:259) at mondrian.olap.fun.FunUtil.hierarchyMembers(FunUtil.java:1851) at mondrian.olap.fun.FunUtil.dimensionMembers(FunUtil.java:1868) at mondrian.olap.fun.BuiltinFunTable$36$1.evaluateList(BuiltinFunTable.java:1010) at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1106) at mondrian.olap.fun.SetFunDef$ListSetCalc$2.evaluateVoid(SetFunDef.java:149) at mondrian.olap.fun.SetFunDef$ListSetCalc.evaluateList(SetFunDef.java:204) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:67) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:694) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:557) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:532) at mondrian.rolap.RolapResult.<init>(RolapResult.java:254) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:597) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:295) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:49) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at sun.reflect.GeneratedMethodAccessor310.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at javax.el.BeanELResolver.getValue(BeanELResolver.java:62) at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54) at org.apache.el.parser.AstValue.getValue(AstValue.java:118) at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186) at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f5(viewOlap_jsp.java:2765) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:413) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:595)

Hello, I haven't mentioned that I already had Jasper Workbench Analysis, and that one of my problem was that I could not generate an MDX query automatically. I solved my problem adding some attributes to the <hierarchy> of the dimension and to the <level> The most important thing is to have in mind the following structure to define a dimension: <dimension><hierarchie><level><Table>. Some attributes are necessary. -the first dimension doesn't work( no MDX query generate) <Dimension type="TimeDimension" foreignKey="ANNEE" name="Annee" caption="ANNEE"> <Hierarchy name="Default" hasAll="true" allMemberName="All Annee" primaryKey="ANNEE"> <Table name="KPSTOCKAGE" schema="BGSADMIN" alias=""> </Table> <Level name="ANNEE" column="ANNEE" type="Time" uniqueMembers="false" levelType="TimeYears"> this way of definig a dimension work <Dimension type="TimeDimension" foreignKey="ANNEE" name="Annee"> <Hierarchy hasAll="true" allMemberName="All Annee" primaryKey="ANNEE"> <Table name="KPSTOCKAGE" schema="BGSADMIN"> </Table> <Level name="Annee" column="ANNEE" ordinalColumn="ANNEE" type="Time" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> -->Solution: some attributes are necessary, but I can't say which one precisely.( I tried to delete some but it is still working). Thank you for your help. David Probst

Hello, I have a problem when I run the MDX query from my logical schema. There is the following error message: Mondrian Error:Error while parsing MDX statement 'select {[Measures].OccupationFS} on columns, {[Annee].[All Annee]} on rows from [CubeTest] ' 0 I think my schema is not correct, whil the data source is very simple: I put all the data in one Table but there are many rows: 48 millions. This is the table, named KPSTOCKAGE ANNEE - VARCHAR(4) FS - VARCHAR(25) GROUPFS - VARCHAR(25) MOIS - VARCHAR(2) OccMoyenne(Mo) - DECIMAL(22, 0) TailleFS(Mo) - DECIMAL(22, 0) UH - CHARThank you. Code:the xml file and mdx query are joined