<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18882"></HEAD>
<BODY 
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV><SPAN class=487533501-08022010><FONT color=#000080 size=2 
face="Lucida Sans">We're working to get a Hudson build of mondrian-3.2 going. It 
just isn't quite up yet. Sorry about that -- and thanks Calum for doing this 
build as a stopgap.</FONT></SPAN></DIV>
<DIV><SPAN class=487533501-08022010><FONT color=#000080 size=2 
face="Lucida Sans"></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=487533501-08022010><FONT color=#000080 size=2 
face="Lucida Sans">Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE 
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" 
dir=ltr>
  <DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
  <HR tabIndex=-1>
  <FONT size=2 face=Tahoma><B>From:</B> mondrian-bounces@pentaho.org 
  [mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Calum 
  Miller<BR><B>Sent:</B> Sunday, February 07, 2010 4:05 PM<BR><B>To:</B> 
  Mondrian developer mailing list<BR><B>Subject:</B> Re: [Mondrian] Dimension 
  filter and Excel + Simba O2X<BR></FONT><BR></DIV>
  <DIV></DIV>Hi Manuel,
  <DIV><BR></DIV>
  <DIV>I've placed a copy of mondrian.jar from build 13343 on my server&nbsp;<A 
  href="http://www.millersoft.ltd.uk/mondrian.jar">http://www.millersoft.ltd.uk/mondrian.jar</A></DIV>
  <DIV>You may also find this video helpful, which explains how to connect Simba 
  up to Mondrian:&nbsp;<A 
  href="http://bit.ly/c6zYSS">http://bit.ly/c6zYSS</A></DIV>
  <DIV><BR></DIV>
  <DIV>Calum</DIV>
  <DIV><BR></DIV>
  <DIV><BR>
  <DIV>
  <DIV>On 5 Feb 2010, at 19:46, Manuel Darveau wrote:</DIV><BR 
  class=Apple-interchange-newline>
  <BLOCKQUOTE type="cite">Hi,<BR><BR>I would like to try the 3.2 branch but it 
    does not seems to be built by <A 
    href="http://ci.pentaho.com">http://ci.pentaho.com</A> and I can't find the 
    SVN repo.<BR>Could you send me the SVN repository URL or a jar of the 
    mondrian 3.2 branch?<BR><BR>Thank you<BR><BR>Manuel<BR><BR>
    <DIV class=gmail_quote>On Fri, Feb 5, 2010 at 10:21 AM, Sergey Mazin <SPAN 
    dir=ltr>&lt;<A 
    href="mailto:sergey.mazin@skype.net">sergey.mazin@skype.net</A>&gt;</SPAN> 
    wrote:<BR>
    <BLOCKQUOTE 
    style="Z-INDEX: auto; POSITION: static; BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" 
    class=gmail_quote>
      <DIV style="WORD-WRAP: break-word" lang=EN-US vlink="purple" link="blue">
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Hi 
      folks,</SPAN></P>
      <DIV><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"></SPAN><BR 
      class=webkit-block-placeholder>&nbsp;</DIV>
      <P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">I 
      think that is the same issue you are facing with.</SPAN></P>
      <P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"><A 
      href="http://jira.pentaho.com/browse/MONDRIAN-678" 
      target=_blank>http://jira.pentaho.com/browse/MONDRIAN-678</A></SPAN></P>
      <DIV><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"></SPAN><BR 
      class=webkit-block-placeholder>&nbsp;</DIV>
      <P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">As 
      Calum suggested pick Mondrian 3.2 from SVN. Build 13343 is more or less 
      stable.</SPAN></P>
      <DIV><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"></SPAN><BR 
      class=webkit-block-placeholder>&nbsp;</DIV>
      <P class=MsoNormal><SPAN 
      style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Regards,</SPAN></P>
      <P class=MsoNormal><SPAN 
      style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Sergey</SPAN></P>
      <DIV><SPAN style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"></SPAN><BR 
      class=webkit-block-placeholder>&nbsp;</DIV>
      <DIV>
      <DIV 
      style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: rgb(181,196,223) 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
      <P class=MsoNormal><B><SPAN style="FONT-SIZE: 10pt">From:</SPAN></B><SPAN 
      style="FONT-SIZE: 10pt"> <A href="mailto:mondrian-bounces@pentaho.org" 
      target=_blank>mondrian-bounces@pentaho.org</A> [mailto:<A 
      href="mailto:mondrian-bounces@pentaho.org" 
      target=_blank>mondrian-bounces@pentaho.org</A>] <B>On Behalf Of </B>Calum 
      Miller<BR><B>Sent:</B> Friday, February 05, 2010 5:11 PM<BR><B>To:</B> <A 
      href="mailto:tom@wamonline.org.uk" target=_blank>tom@wamonline.org.uk</A>; 
      Mondrian developer mailing list<BR><B>Subject:</B> Re: [Mondrian] 
      Dimension filter and Excel + Simba O2X</SPAN></P></DIV></DIV>
      <DIV>
      <DIV></DIV>
      <DIV class=h5>
      <DIV><BR class=webkit-block-placeholder>&nbsp;</DIV>
      <P class=MsoNormal>Hi Tom/Manuel,</P>
      <DIV>
      <DIV><BR class=webkit-block-placeholder>&nbsp;</DIV></DIV>
      <DIV>
      <P class=MsoNormal>The latest Excel/Simba support is in the Mondrian 3.2 
      branch. I'd be interested to learn of any issues you experience with Excel 
      using this branch?</P></DIV>
      <DIV>
      <DIV><BR class=webkit-block-placeholder>&nbsp;</DIV></DIV>
      <DIV>
      <P class=MsoNormal>Calum</P>
      <DIV>
      <DIV>
      <P class=MsoNormal>On 5 Feb 2010, at 15:02, <A 
      href="mailto:tom@wamonline.org.uk" target=_blank>tom@wamonline.org.uk</A> 
      wrote:</P></DIV>
      <P class=MsoNormal><BR><BR></P>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 9pt">Manuel we 
      are doing a simba eval at the moment and get the same error when querying 
      a dimension thats constructed from a &lt;sql&gt;case when.... 
      &lt;/sql&gt;<SPAN>&nbsp;</SPAN><BR><BR>Haven't yet filed a bug report... I 
      dunno who's fault it is ;)<BR><BR>Tom<BR><BR><BR><BR><B>On Fri 5/02/10 
      2:55 PM , Manuel Darveau<SPAN>&nbsp;</SPAN><A 
      href="mailto:manueldarveau@gmail.com" 
      target=_blank>manueldarveau@gmail.com</A><SPAN>&nbsp;</SPAN>sent:</B></SPAN></P>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 9pt">Hi,<BR><BR>I 
      am using Excel 2007 with the Simba O2X plugin.<BR><BR>I have a pivot table 
      on "Rentals" with only one count mesure ("RentalsCount") and a dimension 
      called "Subscription". The possible values for the "Subscription" 
      dimension are "Casual", "Subscriber" and "Unknown".<BR>If I simply add the 
      dimension, I get a correct result. If I add a filter only on one item of 
      the dimension (say "Casual"), I get a correct result. However, if I filter 
      on two items of the dimension (say "Casual" and "Subscriber"), I get a 
      popup stating that the query did not run.<BR>On the server side I 
      activated some debug and got the following (sorry for the log dump but I 
      tought that it would be usefull):<BR><BR>02.05;09:41:58.626 DEBUG XML/A 
      request content<BR><A href="http://schemas.xmlsoap.org/soap/envelope/" 
      target=_blank>http://schemas.xmlsoap.org/soap/envelope/</A>" xmlns:xsd="<A 
      href="http://www.w3.org/2001/XMLSchema" 
      target=_blank>http://www.w3.org/2001/XMLSchema</A>" xmlns:xsi="<A 
      href="http://www.w3.org/2001/XMLSchema-instance" 
      target=_blank><SPAN>&nbsp;</SPAN></A><A 
      href="http://www.w3.org/2001/XMLSchema-instance" 
      target=_blank>http://www.w3.org/2001/XMLSchema-instance</A>"&gt;<BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>WITH&nbsp; 
      SET [XL_Row_Dim_0] AS 
      'VisualTotals(Distinct(Hierarchize({Ascendants([Subscription].[All 
      Subscriptions].[Casual]), Descendants([Subscription].[All 
      Subscriptions].[Casual]), Ascendants([Subscription].[All 
      Subscriptions].[Subscriber]), Descendants([Subscription].[All 
      Subscriptions].[Subscriber])})))'&nbsp; SELECT NON EMPTY 
      Hierarchize(Intersect({DrilldownLevel({[Subscription].[All 
      Subscriptions]})}, [XL_Row_Dim_0])) DIMENSION PROPERTIES 
      PARENT_UNIQUE_NAME ON COLUMNS&nbsp; FROM [Rentals] WHERE 
      ([Measures].[RentalsCount]) CELL PROPERTIES 
      VALUE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>Multidimensional<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>TupleFormat<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>Provider=Mondrian;DataSource=bixicube;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>1033<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>bixicube<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN><BR><BR>02.05;09:41:58.646 
      DEBUG 1: with set [XL_Row_Dim_0] as 
      'VisualTotals(Distinct(Hierarchize({Ascendants([Subscription].[All 
      Subscriptions].[Casual]), Descendants([Subscription].[All 
      Subscriptions].[Casual]), Ascendants([Subscription].[All 
      Subscriptions].[Subscriber]), Descendants([Subscription].[All 
      Subscriptions].[Subscriber])})))'<BR>select NON EMPTY 
      Hierarchize(Intersect({DrilldownLevel({[Subscription].[All 
      Subscriptions]})}, [XL_Row_Dim_0])) DIMENSION PROPERTIES 
      PARENT_UNIQUE_NAME ON COLUMNS<BR>from [Rentals]<BR>where 
      [Measures].[RentalsCount]<BR><BR>02.05;09:41:58.651 DEBUG 1: exec: 4 
      ms<BR>02.05;09:41:58.651 ERROR Errors when handling XML/A 
      message<BR>mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute 
      failed<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1695)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:642)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.xmla.XmlaHandler.process(XmlaHandler.java:552)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:411)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:311)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      javax.servlet.http.HttpServlet.service(HttpServlet.java:727)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)<BR>&nbsp;&nbsp;&nbsp; 
      at org.mortbay.jetty.Server.handle(Server.java:326)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)<BR>Caused 
      by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error 
      while executing query [with set [XL_Row_Dim_0] as 
      'VisualTotals(Distinct(Hierarchize({Ascendants([Subscription].[All 
      Subscriptions].[Casual]), Descendants([Subscription].[All 
      Subscriptions].[Casual]), Ascendants([Subscription].[All 
      Subscriptions].[Subscriber]), Descendants([Subscription].[All 
      Subscriptions].[Subscriber])})))'<BR>select NON EMPTY 
      Hierarchize(Intersect({DrilldownLevel({[Subscription].[All 
      Subscriptions]})}, [XL_Row_Dim_0])) DIMENSION PROPERTIES 
      PARENT_UNIQUE_NAME ON COLUMNS<BR>from [Rentals]<BR>where 
      [Measures].[RentalsCount]<BR>]<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816)<BR>&nbsp;&nbsp;&nbsp; 
      at mondrian.olap.Util.newInternal(Util.java:1492)<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.olap.Util.newError(Util.java:1508)<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.rolap.RolapConnection.execute(RolapConnection.java:633)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1691)<BR>&nbsp;&nbsp;&nbsp; 
      ... 19 more<BR>Caused by: 
      java.lang.UnsupportedOperationException<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.olap.fun.VisualTotalsFunDef$VisualTotalMember.getOrdinal(VisualTotalsFunDef.java:246)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1854)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1806)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:2841)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:2834)<BR>&nbsp;&nbsp;&nbsp; 
      at java.util.Arrays.mergeSort(Arrays.java:1270)<BR>&nbsp;&nbsp;&nbsp; at 
      java.util.Arrays.sort(Arrays.java:1210)<BR>&nbsp;&nbsp;&nbsp; at 
      java.util.Collections.sort(Collections.java:159)<BR>&nbsp;&nbsp;&nbsp; at 
      mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:735)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.olap.fun.HierarchizeFunDef$1.evaluateMemberList(HierarchizeFunDef.java:56)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:569)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540)<BR>&nbsp;&nbsp;&nbsp; 
      at mondrian.rolap.RolapResult.(RolapResult.java:273)<BR>&nbsp;&nbsp;&nbsp; 
      at 
      mondrian.rolap.RolapConnection.execute(RolapConnection.java:604)<BR>&nbsp;&nbsp;&nbsp; 
      ... 20 more<BR>02.05;09:41:58.653 DEBUG XML/A response 
      content<BR><BR></SPAN><SPAN style="FONT-SIZE: 9pt"><SPAN 
      style="COLOR: black"><A href="http://schemas.xmlsoap.org/soap/envelope/" 
      target=_blank>http://schemas.xmlsoap.org/soap/envelope/</A>" 
      SOAP-ENV:encodingStyle="<A 
      href="http://schemas.xmlsoap.org/soap/encoding/" 
      target=_blank>http://schemas.xmlsoap.org/soap/encoding/</A>" 
      &gt;<BR></SPAN><SPAN style="COLOR: black"><BR><BR></SPAN><SPAN 
      style="COLOR: black"><BR></SPAN><SPAN 
      style="COLOR: black"><BR>&nbsp;<SPAN>&nbsp;</SPAN>SOAP-ENV:Server.00HSBD02<BR>&nbsp;<SPAN>&nbsp;</SPAN>XMLA 
      MDX execute 
      failed<BR>&nbsp;<SPAN>&nbsp;</SPAN>Mondrian<BR>&nbsp;<SPAN>&nbsp;</SPAN><BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN></SPAN><SPAN 
      style="COLOR: black"><A href="http://mondrian.sourceforge.net" 
      target=_blank>http://mondrian.sourceforge.net</A>"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN></SPAN><CODE><SPAN 
      style="COLOR: black; FONT-SIZE: 10pt">00HSBD02</SPAN></CODE><SPAN 
      style="COLOR: black"><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN>The 
      Mondrian XML: 
      java.lang.UnsupportedOperationException<BR>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp;</SPAN></SPAN><SPAN></SPAN><SPAN 
      style="COLOR: black"><BR>&nbsp;<SPAN>&nbsp;</SPAN><BR></SPAN><SPAN 
      style="COLOR: black"><BR></SPAN><SPAN 
      style="COLOR: black"><BR></SPAN><SPAN style="COLOR: black"><BR><BR>I just 
      upgraded to mondrian 3.1.5.13307 (from 3.1.1.12687) since I had other 
      issues with filters probably related to<SPAN>&nbsp;</SPAN><A 
      href="http://jira.pentaho.com/browse/MONDRIAN-295" 
      target=_blank>http://jira.pentaho.com/browse/MONDRIAN-295</A><SPAN>&nbsp;</SPAN>which 
      is now fixed. My guess is that excel generates MDX that mondrian does not 
      expect but unfortunately, I can't modify the generated MDX.<BR><BR>Is 
      there anything else I can do to help diagnose the problem?<BR><BR>Thank 
      you very much, your support if greatly appreciated.<BR><BR>Manuel 
      Darveau<BR><BR></SPAN><SPAN style="COLOR: black"></SPAN></SPAN></P>
      <P class=MsoNormal><SPAN 
      style="COLOR: black; FONT-SIZE: 9pt"><BR>_______________________________________________<BR>Mondrian 
      mailing list<BR><A href="mailto:Mondrian@pentaho.org" 
      target=_blank>Mondrian@pentaho.org</A><BR><A 
      href="http://lists.pentaho.org/mailman/listinfo/mondrian" 
      target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A></SPAN></P></DIV></DIV>
      <DIV><BR class=webkit-block-placeholder>&nbsp;</DIV>
      <DIV>
      <DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt">Calum 
      Miller</SPAN></P></DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt">Business 
      Intelligence Specialist</SPAN></P></DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt"><A 
      href="mailto:calum@millersoft.ltd.uk" 
      target=_blank>calum@millersoft.ltd.uk</A></SPAN></P></DIV>
      <DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt"><A 
      href="http://www.millersoft.ltd.uk" 
      target=_blank>http://www.millersoft.ltd.uk</A></SPAN></P></DIV></DIV>
      <DIV>
      <P class=MsoNormal><SPAN 
      style="COLOR: black; FONT-SIZE: 13.5pt">Telephone:&nbsp;+44 (0) 131 208 
      0202</SPAN></P></DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt">Mobile: 
      +44 (0) 7973 249 621</SPAN></P></DIV>
      <DIV>
      <P class=MsoNormal><SPAN style="COLOR: black; FONT-SIZE: 13.5pt">Skype: 
      calummiller</SPAN></P></DIV>
      <P class=MsoNormal><SPAN 
      style="COLOR: black; FONT-SIZE: 13.5pt"><BR><SPAN>&lt;image001.jpg&gt;</SPAN></SPAN></P></DIV></DIV>
      <DIV><BR 
      class=webkit-block-placeholder>&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>Mondrian 
      mailing list<BR><A 
      href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A><BR><A 
      href="http://lists.pentaho.org/mailman/listinfo/mondrian" 
      target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR><BR></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>Mondrian 
    mailing list<BR><A 
    href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A><BR>http://lists.pentaho.org/mailman/listinfo/mondrian<BR></BLOCKQUOTE></DIV><BR>
  <DIV apple-content-edited="true"><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span><SPAN 
  style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" 
  class=Apple-style-span>
  <DIV 
  style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
  <DIV>Calum Miller</DIV>
  <DIV>Business Intelligence Specialist</DIV>
  <DIV><A 
href="mailto:calum@millersoft.ltd.uk">calum@millersoft.ltd.uk</A></DIV>
  <DIV>
  <DIV><A 
  href="http://www.millersoft.ltd.uk">http://www.millersoft.ltd.uk</A></DIV></DIV>
  <DIV>Telephone:&nbsp;+44 (0) 131 208 0202</DIV>
  <DIV>Mobile: +44 (0) 7973 249 621</DIV>
  <DIV>Skype: calummiller</DIV><BR 
  class=Apple-interchange-newline><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN><IMG 
  src="cid:487533501@08022010-0BD8" width=300 height=82></SPAN> 
  </DIV></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>