Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-2563

Importing a Mondrian schema using Manage Datasources Perspective does not escape "<" (less than symbol) character when used in calculated measure

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Not a Bug
    • Affects Version/s: 7.0.0 GA
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide
      1. Setup a vanilla 7.0.0.25
      2. Once the server is up and running log into PUC
      3. Download the SteelWheels Analysis Schema
      4. Edit the schema from step 3 using notepad++ and add the following calculated measure
        <CalculatedMember name="Adjusted Quantity" formatString="" formula="IIF([Measures].[Quantity] < 5000, [Measures].[Quantity]*1000, [Measures].[Quantity])" dimension="Measures" visible="true">
        </CalculatedMember>
        
      1. Log into PUC and attempt to import the modified schema

      Actual Results
      A screenshot is shown stating Publish to Server General Error:
      (Please see screenshot and stacktrace)

      Expected Results
      We should be able to import the schema without modification

      Show
      Setup a vanilla 7.0.0.25 Once the server is up and running log into PUC Download the SteelWheels Analysis Schema Edit the schema from step 3 using notepad++ and add the following calculated measure <CalculatedMember name= "Adjusted Quantity" formatString= "" formula=" IIF([Measures].[Quantity] < 5000, [Measures].[Quantity]*1000, [Measures].[Quantity]) " dimension=" Measures " visible=" true"> </CalculatedMember> Log into PUC and attempt to import the modified schema Actual Results A screenshot is shown stating Publish to Server General Error: (Please see screenshot and stacktrace) Expected Results We should be able to import the schema without modification

      Description

      When importing a Mondrian schema that uses "<" (less than symbol) we failed to import the schema and show a general error according to attached screenshot and the following stacktrace is capture in the console.out

      Mar 09, 2017 11:54:32 AM com.sun.jersey.spi.inject.Errors processErrorMessages
      WARNING: The following warnings have been detected with resource and/or provider classes:
        WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.pentaho.platform.web.http.api.resources.EmailResource.deleteEmailConfig(org.pentaho.platform.plugin.services.email.EmailConfiguration), should not consume any entity.
      org.pentaho.platform.plugin.services.importer.PlatformImportException: MondrianCatalogHelper.ERROR_0004 - already exists
              at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:115)
              at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:117)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.processMondrianImport(AnalysisService.java:258)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.putMondrianSchema(AnalysisService.java:163)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.putMondrianSchema(AnalysisDatasourceService.java:93)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.postMondrainSchema(AnalysisDatasourceService.java:144)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
              at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
              at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
              at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
              at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:112)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:117)
              at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184)
              at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
              at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125)
              at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
              at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
              at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
              at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
              at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)
              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:745)
      11:55:32,313 ERROR [AnalysisDatasourceService] Error putMondrianSchema MondrianCatalogHelper.ERROR_0004 - already exists status = 8
      11:55:35,296 ERROR [MondrianCatalogHelper] MondrianCatalogHelper.ERROR_0008 - an error occurred
      org.eigenbase.xom.XOMException: Document parse failed: [Fatal Error] :113:97: The value of attribute "formula" associated with an element type "CalculatedMember" must not contain the '<' character.
      
              at org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(GenericDOMParser.java:170)
              at org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(JaxpDOMParser.java:75)
              at org.eigenbase.xom.wrappers.GenericDOMParser.parse(GenericDOMParser.java:90)
              at org.eigenbase.xom.wrappers.GenericDOMParser.parse(GenericDOMParser.java:82)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.makeSchema(MondrianCatalogHelper.java:1024)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.loadCatalogsIntoCache(MondrianCatalogHelper.java:863)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.init(MondrianCatalogHelper.java:272)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.reInit(MondrianCatalogHelper.java:281)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:653)
              at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:109)
              at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:117)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.processMondrianImport(AnalysisService.java:258)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.putMondrianSchema(AnalysisService.java:163)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.putMondrianSchema(AnalysisDatasourceService.java:93)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.postMondrainSchema(AnalysisDatasourceService.java:144)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
              at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
              at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
              at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
              at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:112)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:117)
              at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184)
              at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
              at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125)
              at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
              at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
              at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
              at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
              at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)
              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:745)
      11:55:35,304 ERROR [MondrianCatalogHelper] MondrianCatalogHelper.ERROR_0013 - Failed to load schema mondrian:/SteelWheels
      mondrian.olap.MondrianException: Mondrian Error:Internal error: MondrianCatalogHelper.ERROR_0009 - while parsing catalog <Schema name="SteelWheels">
              <Cube name="SteelWheelsSales" cache="true" enabled="true">
                      <Table name="ORDERFACT">
                      </Table>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Markets">
                              <Hierarchy hasAll="true" allMemberName="All Markets" primaryKey="CUSTOMERNUMBER" primaryKeyTable="">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Territory" column="TERRITORY" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                <!--Property name="CHART_SERIES_COLOR" column="TERRITORY_COLOR" type="String">
                </Property-->
                                      </Level>
              <Level name="Country" column="COUNTRY" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="State Province" column="STATE" type="String" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">state</Annotation>
                  <Annotation name="Geo.RequiredParents">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="City" column="CITY" type="String" levelType="Regular" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">city</Annotation>
                  <Annotation name="Geo.RequiredParents">country,state</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Customers">
                              <Hierarchy hasAll="true" allMemberName="All Customers" primaryKey="CUSTOMERNUMBER">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Customer" column="CUSTOMERNAME" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                          <Property name="Customer Number" column="CUSTOMERNUMBER" type="Numeric"/>
                          <Property name="Contact First Name" column="CONTACTFIRSTNAME" type="String"/>
                          <Property name="Contact Last Name" column="CONTACTLASTNAME" type="String"/>
                          <Property name="Phone" column="PHONE" type="String"/>
                          <Property name="Address" column="ADDRESSLINE1" type="String"/>
                          <Property name="Credit Limit" column="CREDITLIMIT" type="Numeric"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="PRODUCTCODE" name="Product">
            <Hierarchy name="" hasAll="true" allMemberName="All Products" primaryKey="PRODUCTCODE" caption="">
                                      <Table name="PRODUCTS">
                                      </Table>
              <Level name="Line" table="PRODUCTS" column="PRODUCTLINE" type="String" uniqueMembers="false" levelType="Regular"
                     hideMemberIf="Never">
                                      </Level>
              <Level name="Vendor" table="PRODUCTS" column="PRODUCTVENDOR" type="String" uniqueMembers="false"
                     levelType="Regular" hideMemberIf="Never">
                                      </Level>
              <Level name="Product" table="PRODUCTS" column="PRODUCTNAME" type="String" uniqueMembers="true"
                     levelType="Regular" hideMemberIf="Never">
                          <Property name="Code" column="PRODUCTCODE" type="String"/>
                          <Property name="Vendor" column="PRODUCTVENDOR" type="String"/>
                          <Property name="Description" column="PRODUCTDESCRIPTION" type="String"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension type="TimeDimension" foreignKey="TIME_ID" name="Time">
                              <Hierarchy hasAll="true" allMemberName="All Years" primaryKey="TIME_ID">
                                      <Table name="DIM_TIME">
                                      </Table>
              <Level name="Years" column="YEAR_ID" type="Integer" uniqueMembers="true" levelType="TimeYears"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Quarters" column="QTR_NAME" ordinalColumn="QTR_ID" type="String" uniqueMembers="false"
                     levelType="TimeQuarters" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Months" column="MONTH_NAME" ordinalColumn="MONTH_ID" type="String" uniqueMembers="false"
                     levelType="TimeMonths" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q].[MMM]</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="STATUS" name="Order Status">
                              <Hierarchy hasAll="true" allMemberName="All Status Types" primaryKey="STATUS">
                                      <Level name="Type" column="STATUS" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Measure name="Quantity" column="QUANTITYORDERED" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0000cc" /-->
                      </Measure>
                      <Measure name="Sales" column="TOTALPRICE" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0d8ecf" /-->
                      </Measure>
                      <CalculatedMember name="Adjusted Quantity" formatString="" formula="IIF([Measures].[Quantity] < 5000, [Measures].[Quantity]*1000, [Measures].[Quantity])" dimension="Measures" visible="true">
              </CalculatedMember>
              </Cube>
      </Schema>
      
              at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987)
              at mondrian.olap.Util.newInternal(Util.java:2410)
              at mondrian.olap.Util.newError(Util.java:2426)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.makeSchema(MondrianCatalogHelper.java:1065)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.loadCatalogsIntoCache(MondrianCatalogHelper.java:863)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.init(MondrianCatalogHelper.java:272)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.reInit(MondrianCatalogHelper.java:281)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:653)
              at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:109)
              at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:117)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.processMondrianImport(AnalysisService.java:258)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.putMondrianSchema(AnalysisService.java:163)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.putMondrianSchema(AnalysisDatasourceService.java:93)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.postMondrainSchema(AnalysisDatasourceService.java:144)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
              at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
              at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
              at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
              at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:112)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:117)
              at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184)
              at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
              at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125)
              at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
              at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
              at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
              at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
              at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)
              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: org.eigenbase.xom.XOMException: Document parse failed: [Fatal Error] :113:97: The value of attribute "formula" associated with an element type "CalculatedMember" must not contain the '<' character.
      
              at org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(GenericDOMParser.java:170)
              at org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(JaxpDOMParser.java:75)
              at org.eigenbase.xom.wrappers.GenericDOMParser.parse(GenericDOMParser.java:90)
              at org.eigenbase.xom.wrappers.GenericDOMParser.parse(GenericDOMParser.java:82)
              at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.makeSchema(MondrianCatalogHelper.java:1024)
              ... 99 more
      org.pentaho.platform.plugin.services.importer.PlatformImportException: Mondrian Error:Internal error: MondrianCatalogHelper.ERROR_0009 - while parsing catalog <Schema name="SteelWheels">
              <Cube name="SteelWheelsSales" cache="true" enabled="true">
                      <Table name="ORDERFACT">
                      </Table>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Markets">
                              <Hierarchy hasAll="true" allMemberName="All Markets" primaryKey="CUSTOMERNUMBER" primaryKeyTable="">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Territory" column="TERRITORY" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                <!--Property name="CHART_SERIES_COLOR" column="TERRITORY_COLOR" type="String">
                </Property-->
                                      </Level>
              <Level name="Country" column="COUNTRY" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="State Province" column="STATE" type="String" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">state</Annotation>
                  <Annotation name="Geo.RequiredParents">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="City" column="CITY" type="String" levelType="Regular" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">city</Annotation>
                  <Annotation name="Geo.RequiredParents">country,state</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Customers">
                              <Hierarchy hasAll="true" allMemberName="All Customers" primaryKey="CUSTOMERNUMBER">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Customer" column="CUSTOMERNAME" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                          <Property name="Customer Number" column="CUSTOMERNUMBER" type="Numeric"/>
                          <Property name="Contact First Name" column="CONTACTFIRSTNAME" type="String"/>
                          <Property name="Contact Last Name" column="CONTACTLASTNAME" type="String"/>
                          <Property name="Phone" column="PHONE" type="String"/>
                          <Property name="Address" column="ADDRESSLINE1" type="String"/>
                          <Property name="Credit Limit" column="CREDITLIMIT" type="Numeric"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="PRODUCTCODE" name="Product">
            <Hierarchy name="" hasAll="true" allMemberName="All Products" primaryKey="PRODUCTCODE" caption="">
                                      <Table name="PRODUCTS">
                                      </Table>
              <Level name="Line" table="PRODUCTS" column="PRODUCTLINE" type="String" uniqueMembers="false" levelType="Regular"
                     hideMemberIf="Never">
                                      </Level>
              <Level name="Vendor" table="PRODUCTS" column="PRODUCTVENDOR" type="String" uniqueMembers="false"
                     levelType="Regular" hideMemberIf="Never">
                                      </Level>
              <Level name="Product" table="PRODUCTS" column="PRODUCTNAME" type="String" uniqueMembers="true"
                     levelType="Regular" hideMemberIf="Never">
                          <Property name="Code" column="PRODUCTCODE" type="String"/>
                          <Property name="Vendor" column="PRODUCTVENDOR" type="String"/>
                          <Property name="Description" column="PRODUCTDESCRIPTION" type="String"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension type="TimeDimension" foreignKey="TIME_ID" name="Time">
                              <Hierarchy hasAll="true" allMemberName="All Years" primaryKey="TIME_ID">
                                      <Table name="DIM_TIME">
                                      </Table>
              <Level name="Years" column="YEAR_ID" type="Integer" uniqueMembers="true" levelType="TimeYears"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Quarters" column="QTR_NAME" ordinalColumn="QTR_ID" type="String" uniqueMembers="false"
                     levelType="TimeQuarters" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Months" column="MONTH_NAME" ordinalColumn="MONTH_ID" type="String" uniqueMembers="false"
                     levelType="TimeMonths" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q].[MMM]</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="STATUS" name="Order Status">
                              <Hierarchy hasAll="true" allMemberName="All Status Types" primaryKey="STATUS">
                                      <Level name="Type" column="STATUS" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Measure name="Quantity" column="QUANTITYORDERED" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0000cc" /-->
                      </Measure>
                      <Measure name="Sales" column="TOTALPRICE" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0d8ecf" /-->
                      </Measure>
                      <CalculatedMember name="Adjusted Quantity" formatString="" formula="IIF([Measures].[Quantity] < 5000, [Measures].[Quantity]*1000, [Measures].[Quantity])" dimension="Measures" visible="true">
              </CalculatedMember>
              </Cube>
      </Schema>
      
              at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:117)
              at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:117)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.processMondrianImport(AnalysisService.java:258)
              at org.pentaho.platform.dataaccess.datasource.api.AnalysisService.putMondrianSchema(AnalysisService.java:163)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.putMondrianSchema(AnalysisDatasourceService.java:93)
              at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.AnalysisDatasourceService.postMondrainSchema(AnalysisDatasourceService.java:144)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
              at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
              at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
              at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
              at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
              at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
              at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
              at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
              at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
              at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:112)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
              at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:117)
              at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184)
              at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
              at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
              at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125)
              at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
              at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
              at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
              at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
              at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
              at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
              at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)
              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
              at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:745)
      11:55:35,392 ERROR [AnalysisDatasourceService] Error putMondrianSchema Mondrian Error:Internal error: MondrianCatalogHelper.ERROR_0009 - while parsing catalog <Schema name="SteelWheels">
              <Cube name="SteelWheelsSales" cache="true" enabled="true">
                      <Table name="ORDERFACT">
                      </Table>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Markets">
                              <Hierarchy hasAll="true" allMemberName="All Markets" primaryKey="CUSTOMERNUMBER" primaryKeyTable="">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Territory" column="TERRITORY" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                <!--Property name="CHART_SERIES_COLOR" column="TERRITORY_COLOR" type="String">
                </Property-->
                                      </Level>
              <Level name="Country" column="COUNTRY" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="State Province" column="STATE" type="String" levelType="Regular"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">state</Annotation>
                  <Annotation name="Geo.RequiredParents">country</Annotation>
                </Annotations>
                                      </Level>
              <Level name="City" column="CITY" type="String" levelType="Regular" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="Data.Role">Geography</Annotation>
                  <Annotation name="Geo.Role">city</Annotation>
                  <Annotation name="Geo.RequiredParents">country,state</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="CUSTOMERNUMBER" name="Customers">
                              <Hierarchy hasAll="true" allMemberName="All Customers" primaryKey="CUSTOMERNUMBER">
                                      <Table name="CUSTOMER_W_TER">
                                      </Table>
              <Level name="Customer" column="CUSTOMERNAME" type="String" uniqueMembers="true" levelType="Regular"
                     hideMemberIf="Never">
                          <Property name="Customer Number" column="CUSTOMERNUMBER" type="Numeric"/>
                          <Property name="Contact First Name" column="CONTACTFIRSTNAME" type="String"/>
                          <Property name="Contact Last Name" column="CONTACTLASTNAME" type="String"/>
                          <Property name="Phone" column="PHONE" type="String"/>
                          <Property name="Address" column="ADDRESSLINE1" type="String"/>
                          <Property name="Credit Limit" column="CREDITLIMIT" type="Numeric"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="PRODUCTCODE" name="Product">
            <Hierarchy name="" hasAll="true" allMemberName="All Products" primaryKey="PRODUCTCODE" caption="">
                                      <Table name="PRODUCTS">
                                      </Table>
              <Level name="Line" table="PRODUCTS" column="PRODUCTLINE" type="String" uniqueMembers="false" levelType="Regular"
                     hideMemberIf="Never">
                                      </Level>
              <Level name="Vendor" table="PRODUCTS" column="PRODUCTVENDOR" type="String" uniqueMembers="false"
                     levelType="Regular" hideMemberIf="Never">
                                      </Level>
              <Level name="Product" table="PRODUCTS" column="PRODUCTNAME" type="String" uniqueMembers="true"
                     levelType="Regular" hideMemberIf="Never">
                          <Property name="Code" column="PRODUCTCODE" type="String"/>
                          <Property name="Vendor" column="PRODUCTVENDOR" type="String"/>
                          <Property name="Description" column="PRODUCTDESCRIPTION" type="String"/>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension type="TimeDimension" foreignKey="TIME_ID" name="Time">
                              <Hierarchy hasAll="true" allMemberName="All Years" primaryKey="TIME_ID">
                                      <Table name="DIM_TIME">
                                      </Table>
              <Level name="Years" column="YEAR_ID" type="Integer" uniqueMembers="true" levelType="TimeYears"
                     hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Quarters" column="QTR_NAME" ordinalColumn="QTR_ID" type="String" uniqueMembers="false"
                     levelType="TimeQuarters" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q]</Annotation>
                </Annotations>
                                      </Level>
              <Level name="Months" column="MONTH_NAME" ordinalColumn="MONTH_ID" type="String" uniqueMembers="false"
                     levelType="TimeMonths" hideMemberIf="Never">
                <Annotations>
                  <Annotation name="AnalyzerDateFormat">[yyyy].['QTR'q].[MMM]</Annotation>
                </Annotations>
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Dimension foreignKey="STATUS" name="Order Status">
                              <Hierarchy hasAll="true" allMemberName="All Status Types" primaryKey="STATUS">
                                      <Level name="Type" column="STATUS" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                      </Level>
                              </Hierarchy>
                      </Dimension>
                      <Measure name="Quantity" column="QUANTITYORDERED" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0000cc" /-->
                      </Measure>
                      <Measure name="Sales" column="TOTALPRICE" formatString="#,###" aggregator="sum">
            <Annotations>
              <Annotation name="AnalyzerBusinessGroup">Measures</Annotation>
            </Annotations>
            <!--CalculatedMemberProperty name="CHART_SERIES_COLOR" value="#0d8ecf" /-->
                      </Measure>
                      <CalculatedMember name="Adjusted Quantity" formatString="" formula="IIF([Measures].[Quantity] < 5000, [Measures].[Quantity]*1000, [Measures].[Quantity])" dimension="Measures" visible="true">
              </CalculatedMember>
              </Cube>
      </Schema>
       status = 2
      

      The only way to import this schema is to use = or > in the calculated formula

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              clopez Carlos Lopez
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: