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] '

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Pentaho BI Platform Tracking by weavelink, 1 year ago
].[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] '
via Pentaho BI Platform Tracking by Benny Chow, 1 year ago
Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]
via Pentaho BI Platform Tracking by Benny Chow, 1 year ago
Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]
via Pentaho BI Platform Tracking by Bill Seyler, 1 year ago
Mondrian Error:Failed to parse query ' with member [Measures].[Variance Percent] as '([Measures].[Variance] / [Measures].[Budget])', format_string = IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) > 2.0), "|#.00%|style='green
via Pentaho BI Platform Tracking by Bill Seyler, 1 year ago
Mondrian Error:Failed to parse query ' with member [Measures].[Variance Percent] as '([Measures].[Variance] / [Measures].[Budget])', format_string = IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) > 2.0), "|#.00%|style='green
via Pentaho BI Platform Tracking by Klaus Mende, 1 year ago
Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
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.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.(Query.java:113)
at mondrian.olap.Query.(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)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:65)
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 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 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.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 java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.