[Mondrian] Bug: Named set + range
Anton Nikitin
cybernelly at gmail.com
Tue Jul 10 10:55:55 EDT 2007
Just have found the following bug (version 2.3.2.8944).
Not sure about latest sources.
The following MDX fails (MSAS 2000 succeedes):
with set [Set1] as '[Product].[Drink]:[Product].[Food]'
select [Set1] on columns, {[Measures].defaultMember} on rows
from Sales
Result:
mondrian.olap.MondrianException: Mondrian Error:Syntax error in MDX
expression '[Product].[Drink]:[Product].[Food]'
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
at mondrian.olap.Parser.parseExpression(Parser.java:796)
at mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)
at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)
at mondrian.olap.Parser.do_action(Parser.java:685)
at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
at mondrian.olap.Parser.parseInternal(Parser.java:755)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)
at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Syntax error at
line 1, column 19, token ':'
at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)
at mondrian.olap.Parser.syntax_error(Parser.java:886)
at java_cup.runtime.lr_parser.parse(lr_parser.java:595)
at mondrian.olap.Parser.parseExpression(Parser.java:791)
... 25 more
mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1,
column 19, token ':'
at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)
at mondrian.olap.Parser.syntax_error(Parser.java:886)
at java_cup.runtime.lr_parser.parse(lr_parser.java:595)
at mondrian.olap.Parser.parseExpression(Parser.java:791)
at mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)
at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)
at mondrian.olap.Parser.do_action(Parser.java:685)
at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
at mondrian.olap.Parser.parseInternal(Parser.java:755)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)
at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
at java.lang.Thread.run(Thread.java:595)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070710/ceed6aeb/attachment.html
More information about the Mondrian
mailing list