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

Intersect should return any VisualTotals members in right-hand set

    Details

    • 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

      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: