mondrian.olap.MondrianException: Mondrian Error:Cube 'Sales': Measure 'Promotion Sales' must contain either a source column or a source expression, but not both

Pentaho BI Platform Tracking | Carlos Lopez | 6 months ago
  1. 0

    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}

    Pentaho BI Platform Tracking | 6 months ago | Carlos Lopez
    mondrian.olap.MondrianException: Mondrian Error:Cube 'Sales': Measure 'Promotion Sales' must contain either a source column or a source expression, but not both
  2. 0

    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}

    Pentaho BI Platform Tracking | 6 months ago | Carlos Lopez
    mondrian.olap.MondrianException: Mondrian Error:Cube 'Sales': Measure 'Promotion Sales' must contain either a source column or a source expression, but not both
  3. 0

    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

    Pentaho BI Platform Tracking | 5 years ago | Rob Fellows
    mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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

    Pentaho BI Platform Tracking | 5 years ago | Rob Fellows
    mondrian.olap.MondrianException: Mondrian Error:Unknown aggregator 'none'; valid aggregators are: 'sum', 'count', 'min', 'max', 'avg', 'dist inct-count'
  6. 0

    FoodMart.xml fails to load/convert

    GitHub | 1 year ago | ericvergnaud
    mondrian.olap.MondrianException: Mondrian Error:Calculated member or named set in cube 'Warehouse and Sales' has bad formula

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. mondrian.resource
      MondrianResource$_Def1.ex
      1. mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:999)
      1 frame
    3. mondrian.rolap
      RolapConnection.<init>
      1. mondrian.rolap.RolapCube.createMeasure(RolapCube.java:334)
      2. mondrian.rolap.RolapCube.<init>(RolapCube.java:266)
      3. mondrian.rolap.RolapSchema.load(RolapSchema.java:621)
      4. mondrian.rolap.RolapSchema.load(RolapSchema.java:449)
      5. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:217)
      6. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:215)
      7. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:67)
      8. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161)
      9. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91)
      9 frames
    4. mondrian.olap
      DriverManager.getConnection
      1. mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
      2. mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
      2 frames
    5. mondrian.olap4j
      MondrianOlap4jDriver.connect
      1. mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162)
      2. mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
      3. mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
      4. mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
      5. mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134)
      5 frames
    6. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:571)
      2. java.sql.DriverManager.getConnection(DriverManager.java:215)
      2 frames
    7. org.pentaho.platform
      PentahoConnectionFactory.getConnection
      1. org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection.connect(MDXOlap4jConnection.java:100)
      2. org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection.setProperties(MDXOlap4jConnection.java:219)
      3. org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:124)
      3 frames
    8. com.pentaho.analyzer
      AnalysisAreaManager.createOlapConnection
      1. com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:136)
      2. com.pentaho.analyzer.service.impl.a.getConnection(SourceFile:55)
      3. com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:63)
      4. com.pentaho.analyzer.service.impl.AnalysisAreaManager.createOlapConnection(SourceFile:108)
      4 frames