mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with member [Measures].[store level] as '[Store].CurrentMember.Level.Name' member [Measures].[store type] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Type"), "No type")' member [Measures].[Store Sqft] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Sqft"), 0.0)' select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[store level], [Measures].[store type], [Measures].[Store Sqft]} ON COLUMNS, {[Store].[All Stores], [Store].[All Stores].[Canada], [Store].[All Stores].[Canada].[BC], [Store].[All Stores].[Canada].[BC].[Vancouver], [Store].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] '

Pentaho BI Platform Tracking | weavelink | 1 decade ago
  1. 0

    Since version 2.1.1 (The previous version I worked with was 2.0.1), it is not possible to get a property from the CurrentMember when the dimension contains more than one hierarchy. Previously it worked just fine. Now my schema doesn't work any more. I replicated the problem using the foodmart data and included a snapshot of the dimension and the MDX query below. Thanks ! --------------------------------------- <Dimension name="Store"> <Hierarchy hasAll="true" primaryKey="store_id"> <Table name="store"/> <Level name="Store Country" column="store_country" uniqueMembers="true"/> <Level name="Store State" column="store_state" uniqueMembers="true"/> <Level name="Store City" column="store_city" uniqueMembers="false"/> <Level name="Store Name" column="store_name" uniqueMembers="true"> <Property name="Store Type" column="store_type"/> <Property name="Store Manager" column="store_manager"/> <Property name="Store Sqft" column="store_sqft" type="Numeric"/> <Property name="Grocery Sqft" column="grocery_sqft" type="Numeric"/> <Property name="Frozen Sqft" column="frozen_sqft" type="Numeric"/> <Property name="Meat Sqft" column="meat_sqft" type="Numeric"/> <Property name="Has coffee bar" column="coffee_bar" type="Boolean"/> <Property name="Street address" column="store_street_address" type="String"/> </Level> </Hierarchy> <Hierarchy caption="Store2" name="Store2" allMemberName="All store2s" hasAll="true" primaryKey="store_id"> <Table name="store"/> <Level name="Store City" column="store_city" uniqueMembers="false"/> <Level name="Store Name" column="store_name" uniqueMembers="true"> <Property name="Store Type" column="store_type"/> <Property name="Store Manager" column="store_manager"/> <Property name="Store Sqft" column="store_sqft" type="Numeric"/> <Property name="Grocery Sqft" column="grocery_sqft" type="Numeric"/> <Property name="Frozen Sqft" column="frozen_sqft" type="Numeric"/> <Property name="Meat Sqft" column="meat_sqft" type="Numeric"/> <Property name="Has coffee bar" column="coffee_bar" type="Boolean"/> <Property name="Street address" column="store_street_address" type="String"/> </Level> </Hierarchy> </Dimension> --------------------------------------- with member [Measures].[store level] as '[Store]. CurrentMember.Level.Name' member [Measures].[store type] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Type"), "No type")' member [Measures].[Store Sqft] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Sqft"), 0.0)' select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[store level], [Measures].[store type], [Measures].[Store Sqft]} ON COLUMNS, {[Store].[All Stores], [Store].[All Stores].[Canada], [Store].[All Stores].[Canada].[BC], [Store].[All Stores].[Canada].[BC].[Vancouver], [Store].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] --------------------------------------- [JPivot] 01 jun 2006 10:58:53,531 ERROR [Session 0B02FB9FAAED6A9AA6D92CCCBF442AE9] com.tonbeller.jpivot. mondrian.MondrianModel#parseMDX: Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with member [Measures].[store level] as '[Store].CurrentMember.Level.Name' member [Measures].[store type] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Type"), "No type")' member [Measures].[Store Sqft] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Sqft"), 0.0)' select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[store level], [Measures].[store type], [Measures].[Store Sqft]} ON COLUMNS, {[Store].[All Stores], [Store].[All Stores].[Canada], [Store].[All Stores].[Canada].[BC], [Store].[All Stores].[Canada].[BC].[Vancouver], [Store].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0. ex(MondrianResource.java:1035) at mondrian.olap.ConnectionBase. parseQuery(ConnectionBase.java:68) at com.tonbeller.jpivot.mondrian.MondrianModel. parseMDX(MondrianModel.java:424) at com.tonbeller.jpivot.mondrian.MondrianModel. setUserMdx(MondrianModel.java:725) at com.tonbeller.jpivot.mondrian.MondrianMdxQuery. setMdxQuery(MondrianMdxQuery.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl. invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.commons.beanutils.PropertyUtilsBean. invokeMethod(PropertyUtilsBean.java:1773) at org.apache.commons.beanutils.PropertyUtilsBean. setSimpleProperty(PropertyUtilsBean.java:1759) at org.apache.commons.beanutils.PropertyUtilsBean. setNestedProperty(PropertyUtilsBean.java:1648) at org.apache.commons.beanutils.PropertyUtilsBean. setProperty(PropertyUtilsBean.java:1677) at org.apache.commons.beanutils.PropertyUtils. setProperty(PropertyUtils.java:559) at com.tonbeller.wcf.convert.EditCtrlConverter. convert(EditCtrlConverter.java:72) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:88) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:111) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:111) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:111) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:111) at com.tonbeller.wcf.convert.ConverterImpl. traverse(ConverterImpl.java:111) at com.tonbeller.wcf.convert.ConverterImpl. validate(ConverterImpl.java:65) at com.tonbeller.wcf.form.FormComponent. validate(FormComponent.java:100) at com.tonbeller.wcf.form.ButtonHandler. request(ButtonHandler.java:94) at com.tonbeller.wcf.controller.DispatcherSupport. request(DispatcherSupport.java:167) at com.tonbeller.wcf.component.ComponentSupport. request(ComponentSupport.java:104) at com.tonbeller.wcf.controller.WcfController. request(WcfController.java:71) at com.tonbeller.wcf.controller. RequestFilter$MyHandler.normalRequest(RequestFilter. java:119) at com.tonbeller.wcf.controller.RequestSynchronizer. handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter. doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain. internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain. doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve. invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve. invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve. invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve. invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve. invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter. service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor. process(Http11Processor.java:869) at org.apache.coyote.http11. Http11BaseProtocol$Http11ConnectionHandler. processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint. processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net. LeaderFollowerWorkerThread. runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads. ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'with member [Measures].[store level] as '[Store].CurrentMember. Level.Name' member [Measures].[store type] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Type"), "No type")' member [Measures].[Store Sqft] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Sqft"), 0.0)' select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[store level], [Measures].[store type], [Measures].[Store Sqft]} ON COLUMNS, {[Store].[All Stores], [Store].[All Stores].[Canada], [Store].[All Stores].[Canada].[BC], [Store].[All Stores].[Canada].[BC].[Vancouver], [Store].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] ' at mondrian.resource.MondrianResource$_Def0. ex(MondrianResource.java:1035) at mondrian.olap.Parser.parseInternal(Parser.java:648) at mondrian.olap.ConnectionBase. parseQuery(ConnectionBase.java:65) ... 42 more Caused by: java.lang.NullPointerException at mondrian.olap.fun.PropertiesFunDef$ResolverImpl. resolve(PropertiesFunDef.java:88) at mondrian.olap.fun.FunTableImpl.getDef(FunTableImpl. java:96) at mondrian.mdx.UnresolvedFunCall. accept(UnresolvedFunCall.java:85) at mondrian.olap.Query$StackValidator.validate(Query. java:879) at mondrian.mdx.UnresolvedFunCall. accept(UnresolvedFunCall.java:83) at mondrian.olap.Query$StackValidator.validate(Query. java:879) at mondrian.olap.Formula.accept(Formula.java:102) at mondrian.olap.Query$StackValidator.validate(Query. java:953) at mondrian.olap.Query.resolve(Query.java:265) at mondrian.olap.Query.resolve(Query.java:221) at mondrian.olap.Query.<init>(Query.java:113) at mondrian.olap.Query.<init>(Query.java:78) at mondrian.olap.Parser.makeQuery(Parser.java:730) at mondrian.olap.CUP$Parser$actions. CUP$Parser$do_action(Parser.java:1577) at mondrian.olap.Parser.do_action(Parser.java:576) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:643) ... 43 more [JPivot] 01 jun 2006 10:58:53,531 ERROR [Session 0B02FB9FAAED6A9AA6D92CCCBF442AE9] com.tonbeller.jpivot. mondrian.MondrianModel#setUserMdx: setUserMdx failed null

    Pentaho BI Platform Tracking | 1 decade ago | weavelink
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with member [Measures].[store level] as '[Store].CurrentMember.Level.Name' member [Measures].[store type] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Type"), "No type")' member [Measures].[Store Sqft] as 'IIf(([Store]. CurrentMember.Level.Name = "Store Name"), [Store]. CurrentMember.Properties("Store Sqft"), 0.0)' select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[store level], [Measures].[store type], [Measures].[Store Sqft]} ON COLUMNS, {[Store].[All Stores], [Store].[All Stores].[Canada], [Store].[All Stores].[Canada].[BC], [Store].[All Stores].[Canada].[BC].[Vancouver], [Store].[All Stores ].[Canada].[BC].[Vancouver].[Store 19], [Store].[All Stores].[Canada].[BC].[Victoria], [Store].[All Stores]. [Mexico], [Store].[All Stores].[USA]} ON ROWS from [Sales] where [Time].[1997] '
  2. 0

    Android: Saving Map State in Google map

    Stack Overflow | 11 months ago | Junie Negentien
    java.lang.RuntimeException: Unable to resume activity {com.ourThesis.junieNegentien2015/com.ourThesis.junieNegentien2015.MainActivity}: java.lang.NullPointerException
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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. java.lang.NullPointerException

      No message provided

      at mondrian.olap.fun.PropertiesFunDef$ResolverImpl.resolve()
    2. mondrian.olap.fun
      FunTableImpl.getDef
      1. mondrian.olap.fun.PropertiesFunDef$ResolverImpl.resolve(PropertiesFunDef.java:88)
      2. mondrian.olap.fun.FunTableImpl.getDef(FunTableImpl.java:96)
      2 frames
    3. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:85)
      1 frame
    4. mondrian.olap
      Query$StackValidator.validate
      1. mondrian.olap.Query$StackValidator.validate(Query.java:879)
      1 frame
    5. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:83)
      1 frame
    6. mondrian.olap
      Parser.do_action
      1. mondrian.olap.Query$StackValidator.validate(Query.java:879)
      2. mondrian.olap.Formula.accept(Formula.java:102)
      3. mondrian.olap.Query$StackValidator.validate(Query.java:953)
      4. mondrian.olap.Query.resolve(Query.java:265)
      5. mondrian.olap.Query.resolve(Query.java:221)
      6. mondrian.olap.Query.<init>(Query.java:113)
      7. mondrian.olap.Query.<init>(Query.java:78)
      8. mondrian.olap.Parser.makeQuery(Parser.java:730)
      9. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1577)
      10. mondrian.olap.Parser.do_action(Parser.java:576)
      10 frames
    7. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
      1 frame
    8. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.Parser.parseInternal(Parser.java:643)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:65)
      2 frames
    9. com.tonbeller.jpivot
      MondrianMdxQuery.setMdxQuery
      1. com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:424)
      2. com.tonbeller.jpivot.mondrian.MondrianModel.setUserMdx(MondrianModel.java:725)
      3. com.tonbeller.jpivot.mondrian.MondrianMdxQuery.setMdxQuery(MondrianMdxQuery.java:45)
      3 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    11. Apache Commons BeanUtils
      PropertyUtils.setProperty
      1. org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
      2. org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:1759)
      3. org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(PropertyUtilsBean.java:1648)
      4. org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUtilsBean.java:1677)
      5. org.apache.commons.beanutils.PropertyUtils.setProperty(PropertyUtils.java:559)
      5 frames
    12. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.convert.EditCtrlConverter.convert(EditCtrlConverter.java:72)
      2. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:88)
      3. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
      4. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
      5. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
      6. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
      7. com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
      8. com.tonbeller.wcf.convert.ConverterImpl.validate(ConverterImpl.java:65)
      9. com.tonbeller.wcf.form.FormComponent.validate(FormComponent.java:100)
      10. com.tonbeller.wcf.form.ButtonHandler.request(ButtonHandler.java:94)
      11. com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)
      12. com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:104)
      13. com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)
      14. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:119)
      15. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
      16. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
      16 frames
    13. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      8 frames
    14. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    15. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame