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

Intersect should return any VisualTotals members in right-hand set

    Details

      Description

      Anton Nikitin wrote:

      > Today I was experimenting with Excel 2007 pivot
      > tables and found that it generates a bit crazy MDX
      > statements.
      >
      > For example, very simple GUI navigation steps cause
      > the following MDX:
      >
      > WITH
      > SET [XL_Row_Dim_0] AS 'VisualTotals(Distinct(Hierarchize({Ascendants([Customers].[All Customers].[USA]), Descendants([Customers].[All Customers].[USA])})))'
      > SELECT
      > NON EMPTY Hierarchize({[Time].[Year].members}) ON COLUMNS ,
      > NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Customers].[All Customers]})}, [XL_Row_Dim_0])) ON ROWS
      > FROM [Sales]
      > WHERE ([Measures].[Store Sales])
      >
      > Mondrian doesn't correctly processes this one (results
      > differ from MSAS 2000).

      Assuming this query is typical of Excel 2007, let's make sure it works. Will, assigning to you.

      Julian

        Activity

        Hide
        Calum Miller added a comment -
        This issue is broader in scope than just Excel

        The following query against the FoodMart Database yields different results in SSAS and Mondrian
        select NON EMPTY Hierarchize(
                           Intersect({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]},
                               VisualTotals(
                                   hierarchize({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]})))) ON COLUMNS
        from [Sales]
        where [Measures].[Sales count]


        Result Excel 2007 -> SSAS
        -------------------------------------
        Axis #0:
        {[Measures].[Sales Count]}
        Axis #1:
        {[Store].[All Stores].[USA]}
        {[Store].[All Stores].[USA].[CA]}
        Row #0: 24,442
        Row #0: 24,442

        Result Excel 2007 -> Mondrian
        -----------------------------------------
        Axis #0:
        {[Measures].[Sales Count]}
        Axis #1:
        {[Store].[All Stores].[USA]}
        {[Store].[All Stores].[USA].[CA]}
        Row #0: 86,837
        Row #0: 24,442


        Mondrian requires the VisualTotals function to be the outer function, so the following query works as expected:

        select NON EMPTY Hierarchize(VisualTotals(Intersect({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]},
                                 {[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]}))) ON COLUMNS
        from [Sales]
        where [Measures].[Sales count]

        Axis #0:
        {[Measures].[Sales Count]}
        Axis #1:
        {[Store].[All Stores].[USA]}
        {[Store].[All Stores].[USA].[CA]}
        Row #0: 24,442
        Row #0: 24,442
        Show
        Calum Miller added a comment - This issue is broader in scope than just Excel The following query against the FoodMart Database yields different results in SSAS and Mondrian select NON EMPTY Hierarchize(                    Intersect({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]},                        VisualTotals(                            hierarchize({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]})))) ON COLUMNS from [Sales] where [Measures].[Sales count] Result Excel 2007 -> SSAS ------------------------------------- Axis #0: {[Measures].[Sales Count]} Axis #1: {[Store].[All Stores].[USA]} {[Store].[All Stores].[USA].[CA]} Row #0: 24,442 Row #0: 24,442 Result Excel 2007 -> Mondrian ----------------------------------------- Axis #0: {[Measures].[Sales Count]} Axis #1: {[Store].[All Stores].[USA]} {[Store].[All Stores].[USA].[CA]} Row #0: 86,837 Row #0: 24,442 Mondrian requires the VisualTotals function to be the outer function, so the following query works as expected: select NON EMPTY Hierarchize(VisualTotals(Intersect({[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]},                          {[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA]}))) ON COLUMNS from [Sales] where [Measures].[Sales count] Axis #0: {[Measures].[Sales Count]} Axis #1: {[Store].[All Stores].[USA]} {[Store].[All Stores].[USA].[CA]} Row #0: 24,442 Row #0: 24,442
        Hide
        Calum Miller added a comment -
        Here is a test case for this issue:

            public void testVisualTotalsWithNamedSetAndPivotSameAxis() {
                assertQueryReturns(
                    "WITH SET [XL_Row_Dim_0] AS\n"
                   +" VisualTotals(\n"
                   +" Distinct(\n"
                   +" Hierarchize(\n"
             +" {Ascendants([Store].[All Stores].[USA].[CA]),\n"
             +" Descendants([Store].[All Stores].[USA].[CA])})))\n"
                   +"select NON EMPTY \n"
                   +" Hierarchize(\n"
                   +" Intersect(\n"
                   +" {DrilldownLevel({[Store].[All Stores].[USA]})},\n"
                   +" [XL_Row_Dim_0])) ON COLUMNS\n"
                   +"from [Sales] "
                   +"where [Measures].[Sales count]\n",
                    "Axis #0:\n"
                   + "{[Measures].[Sales Count]}\n"
                   + "Axis #1:\n"
                   + "{[Store].[All Stores].[USA]}\n"
                   + "{[Store].[All Stores].[USA].[CA]}\n"
                   + "Row #0: 24,442\n"
                   + "Row #0: 24,442\n");
            }
        Show
        Calum Miller added a comment - Here is a test case for this issue:     public void testVisualTotalsWithNamedSetAndPivotSameAxis() {         assertQueryReturns(             "WITH SET [XL_Row_Dim_0] AS\n"            +" VisualTotals(\n"            +" Distinct(\n"            +" Hierarchize(\n"      +" {Ascendants([Store].[All Stores].[USA].[CA]),\n"      +" Descendants([Store].[All Stores].[USA].[CA])})))\n"            +"select NON EMPTY \n"            +" Hierarchize(\n"            +" Intersect(\n"            +" {DrilldownLevel({[Store].[All Stores].[USA]})},\n"            +" [XL_Row_Dim_0])) ON COLUMNS\n"            +"from [Sales] "            +"where [Measures].[Sales count]\n",             "Axis #0:\n"            + "{[Measures].[Sales Count]}\n"            + "Axis #1:\n"            + "{[Store].[All Stores].[USA]}\n"            + "{[Store].[All Stores].[USA].[CA]}\n"            + "Row #0: 24,442\n"            + "Row #0: 24,442\n");     }
        Hide
        Julian Hyde added a comment -
        Fixed on main line in change 13263.
        Show
        Julian Hyde added a comment - Fixed on main line in change 13263.
        Hide
        Agustin Brau added a comment -
        I have upgrade to Mondrian 3.1.5 which is marked as fixed with this issue, but it's weird that if I select only 1 member it works great. But if I chose more than 1 member it gives an exception.

        Have you tried this fix with a bigger dataset? I have found error and Mondrian complains with overflow.

        This is my Excel 2007 query:

        WITH
          SET [XL_Col_Dim_0] AS 'VisualTotals(Distinct(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        SELECT
          NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,[Fecha.Standard].[Anio].[$name] ON COLUMNS
        FROM [VEN_Renta]
        WHERE ([Measures].[Importe]) CELL PROPERTIES VALUE


        The log is attached after.
        Show
        Agustin Brau added a comment - I have upgrade to Mondrian 3.1.5 which is marked as fixed with this issue, but it's weird that if I select only 1 member it works great. But if I chose more than 1 member it gives an exception. Have you tried this fix with a bigger dataset? I have found error and Mondrian complains with overflow. This is my Excel 2007 query: WITH   SET [XL_Col_Dim_0] AS 'VisualTotals(Distinct(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' SELECT   NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,[Fecha.Standard].[Anio].[$name] ON COLUMNS FROM [VEN_Renta] WHERE ([Measures].[Importe]) CELL PROPERTIES VALUE The log is attached after.
        Hide
        Agustin Brau added a comment -
        2010-01-21 15:47:17,340 ERROR [com.tonbeller.wcf.controller.RequestFilter] exeption
        javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS
        from [VEN_Renta]
        where [Measures].[Importe]
        ])
        at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
        at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:425)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
        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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:595)
        2010-01-21 15:47:17,341 ERROR [com.tonbeller.wcf.controller.RequestFilter] cause
        javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS
        from [VEN_Renta]
        where [Measures].[Importe]
        ])
        at org.apache.taglibs.standard.tag.el.core.IfTag.condition(IfTag.java:65)
        at javax.servlet.jsp.jstl.core.ConditionalTagSupport.doStartTag(ConditionalTagSupport.java:84)
        at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:320)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
        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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:595)
        2010-01-21 15:47:17,341 ERROR [com.tonbeller.wcf.controller.RequestFilter] Error handling request
        javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS
        from [VEN_Renta]
        where [Measures].[Importe]
        ])
        at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
        at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:425)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
        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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:595)
        2010-01-21 15:47:17,342 ERROR [com.tonbeller.wcf.controller.RequestFilter] Error handling request
        javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS
        from [VEN_Renta]
        where [Measures].[Importe]
        ])
        at org.apache.taglibs.standard.tag.el.core.IfTag.condition(IfTag.java:65)
        at javax.servlet.jsp.jstl.core.ConditionalTagSupport.doStartTag(ConditionalTagSupport.java:84)
        at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:320)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
        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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:595)
        Show
        Agustin Brau added a comment - 2010-01-21 15:47:17,340 ERROR [com.tonbeller.wcf.controller.RequestFilter] exeption javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS from [VEN_Renta] where [Measures].[Importe] ]) at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:425) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 2010-01-21 15:47:17,341 ERROR [com.tonbeller.wcf.controller.RequestFilter] cause javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS from [VEN_Renta] where [Measures].[Importe] ]) at org.apache.taglibs.standard.tag.el.core.IfTag.condition(IfTag.java:65) at javax.servlet.jsp.jstl.core.ConditionalTagSupport.doStartTag(ConditionalTagSupport.java:84) at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:320) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 2010-01-21 15:47:17,341 ERROR [com.tonbeller.wcf.controller.RequestFilter] Error handling request javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS from [VEN_Renta] where [Measures].[Importe] ]) at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:425) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 2010-01-21 15:47:17,342 ERROR [com.tonbeller.wcf.controller.RequestFilter] Error handling request javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [XL_Col_Dim_0] as 'Distinct(VisualTotals(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' select NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [Fecha.Standard].[Anio].[$name] ON COLUMNS from [VEN_Renta] where [Measures].[Importe] ]) at org.apache.taglibs.standard.tag.el.core.IfTag.condition(IfTag.java:65) at javax.servlet.jsp.jstl.core.ConditionalTagSupport.doStartTag(ConditionalTagSupport.java:84) at org.apache.jsp.jpivotOlap_jsp._jspService(org.apache.jsp.jpivotOlap_jsp:320) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595)
        Hide
        Julian Hyde added a comment -
        JPivot gives the error "overflowOccured" for a lot of reasons. In all that error stack I can't see what the cause of the Mondrian internal error. It possibly wasn't even an internal error.

        I notice that you have "[Fecha.Standard].[Anio].[$name] ON COLUMNS" in your query. Did you intend to substitute $name?
        Show
        Julian Hyde added a comment - JPivot gives the error "overflowOccured" for a lot of reasons. In all that error stack I can't see what the cause of the Mondrian internal error. It possibly wasn't even an internal error. I notice that you have "[Fecha.Standard].[Anio].[$name] ON COLUMNS" in your query. Did you intend to substitute $name?
        Hide
        Agustin Brau added a comment -
        Hi Julian.

        Sorry I have tried this query with the same result

        WITH
          SET [XL_Col_Dim_0] AS 'VisualTotals(Distinct(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))'
        SELECT
          NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) ON COLUMNS
        FROM [VEN_Renta]
        WHERE ([Measures].[Importe])

        I forgot to say that the original Excel query executes without VisualTotals command.
        Show
        Agustin Brau added a comment - Hi Julian. Sorry I have tried this query with the same result WITH   SET [XL_Col_Dim_0] AS 'VisualTotals(Distinct(Hierarchize({Ascendants([Fecha.Standard].[Todos].[2008]), Descendants([Fecha.Standard].[Todos].[2008]), Ascendants([Fecha.Standard].[Todos].[2010]), Descendants([Fecha.Standard].[Todos].[2010])})))' SELECT   NON EMPTY Hierarchize(Intersect({DrilldownLevel({[Fecha.Standard].[Todos]})}, [XL_Col_Dim_0])) ON COLUMNS FROM [VEN_Renta] WHERE ([Measures].[Importe]) I forgot to say that the original Excel query executes without VisualTotals command.
        Hide
        Agustin Brau added a comment -
        The original query was generated by Excel 2007 with SimbaO2X through XMLA. I copy the query from the log and paste it in JPivot, that's why I think it's a Mondrian error.

        I have the TCP Trace log of XMLA protocol related to this problem.

        If you enabled to me to attach files to this thread I can upload it.

        Regards
        Agustín
        Show
        Agustin Brau added a comment - The original query was generated by Excel 2007 with SimbaO2X through XMLA. I copy the query from the log and paste it in JPivot, that's why I think it's a Mondrian error. I have the TCP Trace log of XMLA protocol related to this problem. If you enabled to me to attach files to this thread I can upload it. Regards Agustín
        Hide
        Julian Hyde added a comment -
        The reason you can't attach files is because this bug is fixed. Please create a new jira case.
        Show
        Julian Hyde added a comment - The reason you can't attach files is because this bug is fixed. Please create a new jira case.

          People

          • Assignee:
            Julian Hyde
            Reporter:
            Calum Miller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: