Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-306

Parser should not require braces around range op in WITH SET

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      The MDX containing named set definition as member range fails in Mondrian 2.3.2.8944 (while succedes in MSAS 2000). Workaround: add curly braces over range statement.

      Example:


      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(ApplicationFilterChain.java:252)

            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:856)

            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

            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(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(ApplicationFilterChain.java:252)

            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:856)

            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

            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(Thread.java:595)

        Activity

        Hide
        Mondrian Importer User added a comment -
        {anikitin}, 07/10/2007: IP, Artifact Created: 217.119.25.147 |
        {jhyde}, 07/10/2007: IP, Comment Added: 64.81.57.79 |
        {jhyde}, 07/10/2007: status_id, 1 |
        {jhyde}, 07/10/2007: resolution_id, 100 |
        {jhyde}, 07/10/2007: assigned_to, 100 |
        {jhyde}, 07/10/2007: summary, MDX Parser bug: named set + range |
        {jhyde}, 07/10/2007: close_date, 0
        Show
        Mondrian Importer User added a comment - {anikitin}, 07/10/2007: IP, Artifact Created: 217.119.25.147 | {jhyde}, 07/10/2007: IP, Comment Added: 64.81.57.79 | {jhyde}, 07/10/2007: status_id, 1 | {jhyde}, 07/10/2007: resolution_id, 100 | {jhyde}, 07/10/2007: assigned_to, 100 | {jhyde}, 07/10/2007: summary, MDX Parser bug: named set + range | {jhyde}, 07/10/2007: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 07/10/2007: Logged In: YES
        user_id=312935
        Originator: NO

        Fixed in change 1751352; will be in mondrian-2.4.
        Show
        Mondrian Importer User added a comment - {jhyde}, 07/10/2007: Logged In: YES user_id=312935 Originator: NO Fixed in change 1751352; will be in mondrian-2.4.

          People

          • Assignee:
            Julian Hyde
            Reporter:
            anikitin
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: