[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