[Mondrian] Bug: Named set + range
Anton Nikitin
cybernelly at gmail.com
Tue Jul 10 13:01:34 EDT 2007
Done.
https://sourceforge.net/tracker/index.php?func=detail&aid=1751352&group_id=3
5302&atid=414613
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Julian Hyde
Sent: Tuesday, July 10, 2007 8:29 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] Bug: Named set + range
Seems like a parser bug. The query succeeds if there are braces around the
expression, viz
with set [Set1] as '{[Product].[Drink]:[Product].[Food]}'
select [Set1] on columns, {[Measures].defaultMember} on rows
from Sales
Please log a bug at SF.net.
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Anton Nikitin
Sent: Tuesday, July 10, 2007 7:56 AM
To: 'Mondrian developer mailing list'
Subject: [Mondrian] Bug: Named set + range
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/e8b76fc5/attachment.html
More information about the Mondrian
mailing list