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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    Getting a nullpointer exception when switching displayables in J2ME

    Stack Overflow | 6 years ago | Pallinder
    java.lang.NullPointerException: 0 at javax.microedition.lcdui.Display$ChameleonTunnel.callScreenListener(), bci=46 at com.sun.midp.chameleon.layers.SoftButtonLayer.processCommand(), bci=74 at com.sun.midp.chameleon.layers.SoftButtonLayer.soft1(), bci=37 at com.sun.midp.chameleon.layers.SoftButtonLayer.keyInput(), bci=36 at com.sun.midp.chameleon.CWindow.keyInput(), bci=38 at javax.microedition.lcdui.Display$DisplayEventConsumerImpl.handleKeyEvent(), bci=17 at com.sun.midp.lcdui.DisplayEventListener.process(), bci=277 at com.sun.midp.events.EventQueue.run(), bci=179
  3. 0

    J2ME (Java) - Null Pointer Exception caught in Display Class

    Stack Overflow | 6 years ago | Tom
    java.lang.NullPointerException: 0 at javax.microedition.lcdui.Display$ChameleonTunnel.callScreenListener(), bci=46 at com.sun.midp.chameleon.layers.SoftButtonLayer.processCommand(), bci=74 at com.sun.midp.chameleon.layers.SoftButtonLayer.soft1(), bci=37 at com.sun.midp.chameleon.layers.SoftButtonLayer.keyInput(), bci=36 at com.sun.midp.chameleon.CWindow.keyInput(), bci=38 at javax.microedition.lcdui.Display$DisplayEventConsumerImpl.handleKeyEvent(), bci=17 at com.sun.midp.lcdui.DisplayEventListener.process(), bci=277 at com.sun.midp.events.EventQueue.run(), bci=179
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cloud Foundry v2 in Grails

    Stack Overflow | 2 years ago | angelo087
    java.lang.NullPointerException: Cannot invoke method getAt() on null object
  6. 0

    NullPointerException in MIDlet with left soft key

    Stack Overflow | 6 years ago | berry120
    java.lang.NullPointerException: 0 at javax.microedition.lcdui.Display$ChameleonTunnel.callItemListener(), bci=57 at com.sun.midp.chameleon.layers.SoftButtonLayer.processCommand(), bci=57 at com.sun.midp.chameleon.layers.SoftButtonLayer.soft1(), bci=37 at com.sun.midp.chameleon.layers.SoftButtonLayer.keyInput(), bci=36 at com.sun.midp.chameleon.CWindow.keyInput(), bci=38 at javax.microedition.lcdui.Display$DisplayEventConsumerImpl.handleKeyEvent(), bci=17 at com.sun.midp.lcdui.DisplayEventListener.process(), bci=277 at com.sun.midp.events.EventQueue.run(), bci=179

    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