mondrian.olap.MondrianException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Running the Top 10 Customers sample dashboard fails. Errors look like: Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/topnmdxquery.xaction Exceptions look like: 17:00:01,529 ERROR [MDXLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 17:00:01,529 ERROR [MDXLookupRule] c103921e-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-29771427-1222290001483:topnmdxquery.xactionMDXBaseComponent.ERROR_0006 - Could not execute topnmdxquery.xactio n mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.executeQuery(MDXConnection.java:241) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.runQuery(MDXBaseComponent.java:315) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:181) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:86) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:164) at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55) at org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.OldHome_jsp._jspService(OldHome_jsp.java:169) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) 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:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.Parser.parseInternal(Parser.java:772) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129) ... 83 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802) at mondrian.olap.Util.lookup(Util.java:775) at mondrian.olap.Id.accept(Id.java:105) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.QueryAxis.validate(QueryAxis.java:269) at mondrian.olap.Query.resolve(Query.java:582) at mondrian.olap.Query.resolve(Query.java:429) at mondrian.olap.Query.<init>(Query.java:226) at mondrian.olap.Query.<init>(Query.java:183) at mondrian.olap.Parser.makeQuery(Parser.java:863) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696) at mondrian.olap.Parser.do_action(Parser.java:694) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:767) ... 84 more 17:00:01,561 ERROR [MDXLookupRule] Error end: 17:00:01,561 ERROR [RuntimeContext] c103921e-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-29771427-1222290001483:topnmdxquery.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule did not execute successfully 17:00:01,561 ERROR [ProSolutionEngine] c103921e-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:topnmdxquery.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl
    via by Jared Pshedesky,
  • Running the Top 10 Customers sample dashboard fails. Errors look like: Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/topnmdxquery.xaction Exceptions look like: 17:00:01,529 ERROR [MDXLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 17:00:01,529 ERROR [MDXLookupRule] c103921e-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-29771427-1222290001483:topnmdxquery.xactionMDXBaseComponent.ERROR_0006 - Could not execute topnmdxquery.xactio n mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.executeQuery(MDXConnection.java:241) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.runQuery(MDXBaseComponent.java:315) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:181) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:86) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:164) at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55) at org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.OldHome_jsp._jspService(OldHome_jsp.java:169) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) 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:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.Parser.parseInternal(Parser.java:772) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129) ... 83 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802) at mondrian.olap.Util.lookup(Util.java:775) at mondrian.olap.Id.accept(Id.java:105) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.QueryAxis.validate(QueryAxis.java:269) at mondrian.olap.Query.resolve(Query.java:582) at mondrian.olap.Query.resolve(Query.java:429) at mondrian.olap.Query.<init>(Query.java:226) at mondrian.olap.Query.<init>(Query.java:183) at mondrian.olap.Parser.makeQuery(Parser.java:863) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696) at mondrian.olap.Parser.do_action(Parser.java:694) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:767) ... 84 more 17:00:01,561 ERROR [MDXLookupRule] Error end: 17:00:01,561 ERROR [RuntimeContext] c103921e-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-29771427-1222290001483:topnmdxquery.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule did not execute successfully 17:00:01,561 ERROR [ProSolutionEngine] c103921e-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:topnmdxquery.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart_en.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: samples/steel-wheels/homeDashboard/Chart.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 17:00:01,561 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl
    via by Jared Pshedesky,
  • The following code throws an exception. If three tables are joined in one dimension hierarchy, and only two of those tables are joined in another hierarchy within the same dimension, a Duplicate Alias exception is thrown. final TestContext testContext = TestContext.create( null, "<Cube name=\"AliasedDimensionsTesting\" defaultMeasure=\"Supply Time\">\n" + " <Table name=\"sales_fact_1997\"/>\n" + "<Dimension name=\"Store\" foreignKey=\"store_id\">\n" + "<Hierarchy hasAll=\"true\" primaryKeyTable=\"store\" primaryKey=\"store_id\">\n" + " <Join leftKey=\"region_id\" rightKey=\"region_id\">\n" + " <Table name=\"store\"/>\n" + " <Join leftKey=\"sales_district_id\" rightKey=\"promotion_id\">\n" + " <Table name=\"region\"/>\n" + " <Table name=\"promotion\"/>\n" + " </Join>\n" + " </Join>\n" + " <Level name=\"Store Country\" table=\"store\" column=\"store_country\"/>\n" + " <Level name=\"Store Region\" table=\"region\" column=\"sales_region\" />\n" + " <Level name=\"Store Name\" table=\"store\" column=\"store_name\" />\n" + "</Hierarchy>\n" + "<Hierarchy name=\"MyHierarchy\" hasAll=\"true\" primaryKeyTable=\"store\" primaryKey=\"store_id\">\n" + " <Join leftKey=\"region_id\" rightKey=\"region_id\">\n" + " <Table name=\"store\"/>\n" + " <Table name=\"region\"/>\n" + " </Join>\n" + " <Level name=\"Store Country\" table=\"store\" column=\"store_country\"/>\n" + " <Level name=\"Store Region\" table=\"region\" column=\"sales_region\" />\n" + " <Level name=\"Store Name\" table=\"store\" column=\"store_name\" />\n" + "</Hierarchy>\n" + "</Dimension>\n" + "<Dimension name=\"Customers\" foreignKey=\"customer_id\">\n" + "<Hierarchy hasAll=\"true\" allMemberName=\"All Customers\" primaryKeyTable=\"customer\" primaryKey=\"customer_id\">\n" + " <Join leftKey=\"customer_region_id\" rightKey=\"region_id\">\n" + " <Table name=\"customer\"/>\n" + " <Table name=\"region\"/>\n" + " </Join>\n" + " <Level name=\"Country\" table=\"customer\" column=\"country\" uniqueMembers=\"true\"/>\n" + " <Level name=\"Region\" table=\"region\" column=\"sales_region\" uniqueMembers=\"true\"/>\n" + " <Level name=\"City\" table=\"customer\" column=\"city\" uniqueMembers=\"false\"/>\n" + " <Level name=\"Name\" table=\"customer\" column=\"customer_id\" type=\"Numeric\" uniqueMembers=\"true\"/>\n" + "</Hierarchy>\n" + "</Dimension>\n" + "<Measure name=\"Unit Sales\" column=\"unit_sales\" aggregator=\"sum\" formatString=\"Standard\"/>\n" + "</Cube>", null, null, null, null); The exception is: mondrian.olap.MondrianException: Mondrian Error:Duplicate table alias 'region' in cube 'AliasedDimensionsTesting' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802) at mondrian.rolap.RolapCube.validateRelation(RolapCube.java:586) at mondrian.rolap.RolapCube.validateRelation(RolapCube.java:571) at mondrian.rolap.RolapCube.validate(RolapCube.java:548) at mondrian.rolap.RolapSchema.load(RolapSchema.java:439) at mondrian.rolap.RolapSchema.load(RolapSchema.java:335) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:930) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:733) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:152) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:83) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at mondrian.olap.DriverManager.getConnection(DriverManager.java:74) at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:214) at mondrian.test.TestContext.getConnection(TestContext.java:194) at mondrian.test.TestContext.executeQuery(TestContext.java:452) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:692) at mondrian.test.SchemaTest.testMultiJoinsInDimension(SchemaTest.java:546) 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:585) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
    via by Will Gorman,
  • DB Tables data source (Star schema) don't show as available data sources in analyzer. Repro: 1. create a new DB Tables Data Source, select star schema 2. complete the data source, Keep model that get's generated. 3. create a new analyzer report 4. notice that the new data source is not available to select *notice that there is an exception in the console: 11:10:26,969 ERROR [Logger] misc-java.lang.String: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Locale=en_US; Catalog=solution:admin/resources/metadata/dbTables.mondrian.xml; Provider=mondrian mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) 11:10:26,998 ERROR [j] mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'mi n', 'max', 'avg', 'distinct-count' java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count' , 'min', 'max', 'avg', 'distinct-count' at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:108) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', ' avg', 'distinct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) ... 74 more 11:10:28,136 ERROR [DefaultThemeManager] Unable to retrieve module theme for (analyzer) as the module theme definition was not found
    via by Rob Fellows,
  • here is the case with foodmart.xml I run those updates in pg_admin, in order to rename the employe id from 1 to 99999 : update employee set employee_id='99999' where employee_id='1' update employee set supervisor_id='99999' where supervisor_id='1' update employee_closure set employee_id='99999' where employee_id='1' update employee_closure set supervisor_id='99999' where supervisor_id='1' With hasAll=true on the employee hierarchy, it seems to have no problems. But as our hierarchies already have an "all" member, we decided to set hasAll=false. (This also allow us to have a correct total, but I don't know if it is a side effect or a feature) If you set the hierarchy in FoodMart.xml that way : <Dimension name="Employees" foreignKey="employee_id"> <Hierarchy hasAll="false" defaultMember="Sheri Nowmer" primaryKey="employee_id"> <Table name="employee"/> <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> <Closure parentColumn="supervisor_id" childColumn="employee_id"> <Table name="employee_closure"/> </Closure> <Property name="Marital Status" column="marital_status"/> <Property name="Position Title" column="position_title"/> <Property name="Gender" column="gender"/> <Property name="Salary" column="salary"/> <Property name="Education Level" column="education_level"/> <Property name="Management Role" column="management_role"/> </Level> </Hierarchy> </Dimension> and run in a short class that directly query mondrian the following MDX : select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Hierarchize(Union(Crossjoin({[Position].[All Position]}, {[Employees].[Sheri Nowmer]}), Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children))) ON ROWS from [HR] where [Time].[1997] you get in console : ... DEBUG [main] - Util.lookupCompound: parent.name=Employees, category=member, names=[Sheri Nowmer] DEBUG [main] - 2: SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST] ... DEBUG [main] - 2: , exec 23 ms DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec 23 ms WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. ... etc, lot of warn messages ... DEBUG [main] - 2: , exec+fetch 135 ms, 1155 rows DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: done executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec+fetch 135 ms, 1155 rows DEBUG [Mondrian Monitor] - SqlStatementEndEvent(2) DEBUG [main] - HierarchyBase.lookupChild: name=Employees, childname=[Sheri Nowmer] returning elementname=Sheri Nowmer DEBUG [main] - Util.lookupCompound: found child.name=Sheri Nowmer, child.class=mondrian.rolap.SqlMemberSource$RolapParentChildMember DEBUG [main] - Normal cardinality for [Employees] DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - RolapCube.createUsage: cube=HR, hierarchy=Employees$Closure, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - RolapCube.getUsages: name=Employees$Closure ... etc ... Axis #0: {[Time].[1997]} Axis #1: {[Measures].[Org Salary]} {[Measures].[Count]} Axis #2: {[Position].[All Position], [Employees].[Sheri Nowmer].[Derrick Whelply]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Michael Spence]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Maya Gutierrez]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Roberta Damstra]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Rebecca Kanagaki]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Darren Stanz]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Donna Arnold]} Row #0: 36 494,07 € Row #0: 7 236 Row #1: Row #1: Row #2: Row #2: Row #3: 428,76 € Row #3: 36 Row #4: 234,36 € Row #4: 24 Row #5: 832,68 € Row #5: 60 Row #6: 577,80 € Row #6: 24 So you get the WARN message that tells the hierarchy is not in the correct order, but the result seems ok. In JPivot, when you try to use the navigator component, you get all the record directly (like a sql resultset) instead of a well built hierarchy. (I haven't get how it queries mondrian yet) If we do not use Closure Table there's a lot of query on the employee table but that's ok because only closure table allow to load hierarchy in a few query. But it ends with that error : Exception in thread "main" mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33) Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Employees].[Sheri Nowmer]' not found in cube 'HR' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959) at mondrian.olap.Util.lookup(Util.java:1079) at mondrian.olap.Id.accept(Id.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) at mondrian.olap.Query.resolve(Query.java:561) at mondrian.olap.Query.resolve(Query.java:446) at mondrian.olap.Query.<init>(Query.java:200) at mondrian.olap.Query.<init>(Query.java:161) at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184) at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016) at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 3 more Damien
    via by damien hostin,
  • Currently in Pentaho Schema Workbench you can declare a Measure using the Measure column attribute and the Measure Expression. Please see this declaration: {noformat} <Measure name="Promotion Sales" column="store_sales" formatString="#,###.00" aggregator="sum"> <MeasureExpression> <SQL dialect="generic"> <![CDATA[case when sales_fact_1997.promotion_id = 0 then 0 else null end]]> </SQL> </MeasureExpression> </Measure> {noformat} Pentaho Schema Workbench does not indicate this is not supported; please see attached screenshot (PSW.png) and because there is no warning any user can publish the schema with the above declaration and when attempting to use the cube in Analyzer will be shown the following stacktrace: {noformat} 2016-06-13 16:17:06,157 ERROR [org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection] MDXConnection.ERROR_0002 - Invalid connection properties: driver=mondrian.olap4j.MondrianOlap4jDriver;url=jdbc:mondrian:DataSource=MyFoodmart; EnableXmla=false; Locale=en; Catalog=mondrian:/MYFoodmart mondrian.olap.MondrianException: Mondrian Error:Cube 'Sales': Measure 'Promotion Sales' must contain either a source column or a source expression, but not both at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:999) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:334) at mondrian.rolap.RolapCube.<init>(RolapCube.java:266) at mondrian.rolap.RolapSchema.load(RolapSchema.java:621) at mondrian.rolap.RolapSchema.load(RolapSchema.java:449) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:217) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:215) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:67) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection.connect(MDXOlap4jConnection.java:100) at org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection.setProperties(MDXOlap4jConnection.java:219) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:124) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:136) at com.pentaho.analyzer.service.impl.a.getConnection(SourceFile:55) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:63) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) {noformat}
    via by Carlos Lopez,
  • DB Tables data source (Star schema) don't show as available data sources in analyzer. Repro: 1. create a new DB Tables Data Source, select star schema 2. complete the data source, Keep model that get's generated. 3. create a new analyzer report 4. notice that the new data source is not available to select *notice that there is an exception in the console: 11:10:26,969 ERROR [Logger] misc-java.lang.String: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Locale=en_US; Catalog=solution:admin/resources/metadata/dbTables.mondrian.xml; Provider=mondrian mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) 11:10:26,998 ERROR [j] mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'mi n', 'max', 'avg', 'distinct-count' java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count' , 'min', 'max', 'avg', 'distinct-count' at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:108) at com.pentaho.analyzer.service.impl.d.getConnection(SourceFile:26) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:42) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108) at com.pentaho.analyzer.content.a.j.a(SourceFile:68) at com.pentaho.analyzer.content.a.j.dj(SourceFile:95) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:136) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16 9) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:23 5) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter .java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', ' avg', 'distinct-count' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858) at mondrian.rolap.RolapBaseCubeMeasure.<init>(RolapBaseCubeMeasure.java:116) at mondrian.rolap.RolapCube.createMeasure(RolapCube.java:340) at mondrian.rolap.RolapCube.<init>(RolapCube.java:251) at mondrian.rolap.RolapSchema.load(RolapSchema.java:442) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:227) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:146) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:106) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:129) at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:98) ... 74 more 11:10:28,136 ERROR [DefaultThemeManager] Unable to retrieve module theme for (analyzer) as the module theme definition was not found
    via by Rob Fellows,
  • here is the case with foodmart.xml I run those updates in pg_admin, in order to rename the employe id from 1 to 99999 : update employee set employee_id='99999' where employee_id='1' update employee set supervisor_id='99999' where supervisor_id='1' update employee_closure set employee_id='99999' where employee_id='1' update employee_closure set supervisor_id='99999' where supervisor_id='1' With hasAll=true on the employee hierarchy, it seems to have no problems. But as our hierarchies already have an "all" member, we decided to set hasAll=false. (This also allow us to have a correct total, but I don't know if it is a side effect or a feature) If you set the hierarchy in FoodMart.xml that way : <Dimension name="Employees" foreignKey="employee_id"> <Hierarchy hasAll="false" defaultMember="Sheri Nowmer" primaryKey="employee_id"> <Table name="employee"/> <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> <Closure parentColumn="supervisor_id" childColumn="employee_id"> <Table name="employee_closure"/> </Closure> <Property name="Marital Status" column="marital_status"/> <Property name="Position Title" column="position_title"/> <Property name="Gender" column="gender"/> <Property name="Salary" column="salary"/> <Property name="Education Level" column="education_level"/> <Property name="Management Role" column="management_role"/> </Level> </Hierarchy> </Dimension> and run in a short class that directly query mondrian the following MDX : select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Hierarchize(Union(Crossjoin({[Position].[All Position]}, {[Employees].[Sheri Nowmer]}), Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children))) ON ROWS from [HR] where [Time].[1997] you get in console : ... DEBUG [main] - Util.lookupCompound: parent.name=Employees, category=member, names=[Sheri Nowmer] DEBUG [main] - 2: SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST] ... DEBUG [main] - 2: , exec 23 ms DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec 23 ms WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. WARN [main] - The level [Employees].[Employee Id] makes use of the 'parentColumn' attribute, but a parent member for key 2 is missing. This can be due to the usage of the NativizeSet MDX function with a list of members form a parent-child hierarchy that doesn't include all parent members in its definition. Using NativizeSet with a parent-child hierarchy requires the parent members to be included in the set, or the hierarchy cannot be properly built natively. ... etc, lot of warn messages ... DEBUG [main] - 2: , exec+fetch 135 ms, 1155 rows DEBUG [main] - SqlTupleReader.readTuples [[Employees].[Employee Id]]: done executing sql [select "employee"."supervisor_id" as "c0", "employee"."employee_id" as "c1", "employee"."full_name" as "c2", "employee"."marital_status" as "c3", "employee"."position_title" as "c4", "employee"."gender" as "c5", "employee"."salary" as "c6", "employee"."education_level" as "c7", "employee"."management_role" as "c8" from "employee" as "employee" group by "employee"."supervisor_id", "employee"."employee_id", "employee"."full_name", "employee"."marital_status", "employee"."position_title", "employee"."gender", "employee"."salary", "employee"."education_level", "employee"."management_role" order by "employee"."supervisor_id" ASC NULLS FIRST, "employee"."employee_id" ASC NULLS LAST], exec+fetch 135 ms, 1155 rows DEBUG [Mondrian Monitor] - SqlStatementEndEvent(2) DEBUG [main] - HierarchyBase.lookupChild: name=Employees, childname=[Sheri Nowmer] returning elementname=Sheri Nowmer DEBUG [main] - Util.lookupCompound: found child.name=Sheri Nowmer, child.class=mondrian.rolap.SqlMemberSource$RolapParentChildMember DEBUG [main] - Normal cardinality for [Employees] DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension DEBUG [main] - RolapCube.createUsage: cube=HR, hierarchy=Employees$Closure, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - Normal cardinality for [Employees$Closure] DEBUG [main] - RolapCube.getUsages: name=Employees$Closure ... etc ... Axis #0: {[Time].[1997]} Axis #1: {[Measures].[Org Salary]} {[Measures].[Count]} Axis #2: {[Position].[All Position], [Employees].[Sheri Nowmer].[Derrick Whelply]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Michael Spence]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Maya Gutierrez]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Roberta Damstra]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Rebecca Kanagaki]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Darren Stanz]} {[Position].[All Position], [Employees].[Sheri Nowmer].[Donna Arnold]} Row #0: 36 494,07 € Row #0: 7 236 Row #1: Row #1: Row #2: Row #2: Row #3: 428,76 € Row #3: 36 Row #4: 234,36 € Row #4: 24 Row #5: 832,68 € Row #5: 60 Row #6: 577,80 € Row #6: 24 So you get the WARN message that tells the hierarchy is not in the correct order, but the result seems ok. In JPivot, when you try to use the navigator component, you get all the record directly (like a sql resultset) instead of a well built hierarchy. (I haven't get how it queries mondrian yet) If we do not use Closure Table there's a lot of query on the employee table but that's ok because only closure table allow to load hierarchy in a few query. But it ends with that error : Exception in thread "main" mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33) Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Employees].[Sheri Nowmer]' not found in cube 'HR' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959) at mondrian.olap.Util.lookup(Util.java:1079) at mondrian.olap.Id.accept(Id.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) at mondrian.olap.Query.resolve(Query.java:561) at mondrian.olap.Query.resolve(Query.java:446) at mondrian.olap.Query.<init>(Query.java:200) at mondrian.olap.Query.<init>(Query.java:161) at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184) at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016) at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 3 more Damien
    via by damien hostin,
    • mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales ]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.executeQuery(MDXConnection.java:241) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.runQuery(MDXBaseComponent.java:315) at org.pentaho.platform.plugin.action.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:181) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:86) at org.pentaho.platform.uifoundation.chart.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:164) at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55) at org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.OldHome_jsp._jspService(OldHome_jsp.java:169) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) 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:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'select NON EMPTY {[Measures].[Sales]} ON COLUMNS,NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] where ([Markets].[All Markets].[{territory}])' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.Parser.parseInternal(Parser.java:772) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129) ... 83 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Markets].[All Markets].[{territory}]' not found in cube 'SteelWheelsSales' at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802) at mondrian.olap.Util.lookup(Util.java:775) at mondrian.olap.Id.accept(Id.java:105) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99) at mondrian.olap.Query$StackValidator.validate(Query.java:1260) at mondrian.olap.QueryAxis.validate(QueryAxis.java:269) at mondrian.olap.Query.resolve(Query.java:582) at mondrian.olap.Query.resolve(Query.java:429) at mondrian.olap.Query.<init>(Query.java:226) at mondrian.olap.Query.<init>(Query.java:183) at mondrian.olap.Parser.makeQuery(Parser.java:863) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696) at mondrian.olap.Parser.do_action(Parser.java:694) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:767) ... 84 more
    No Bugmate found.