<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="<a href=" xmlns:ns1="">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:56.7pt 42.5pt 56.7pt 85.05pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='word-wrap: break-word;
-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi folks,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I think that is the same issue you are facing with.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://jira.pentaho.com/browse/MONDRIAN-678">http://jira.pentaho.com/browse/MONDRIAN-678</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>As Calum suggested pick Mondrian 3.2 from SVN. Build 13343 is
more or less stable.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Sergey<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org] <b>On Behalf
Of </b>Calum Miller<br>
<b>Sent:</b> Friday, February 05, 2010 5:11 PM<br>
<b>To:</b> tom@wamonline.org.uk; Mondrian developer mailing list<br>
<b>Subject:</b> Re: [Mondrian] Dimension filter and Excel + Simba O2X<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi Tom/Manuel,<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</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?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Calum<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal>On 5 Feb 2010, at 15:02, <a
href="mailto:tom@wamonline.org.uk">tom@wamonline.org.uk</a> wrote:<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";
color:black'>Manuel we are doing a simba eval at the moment and get the same
error when querying a dimension thats constructed from a <sql>case
when.... </sql><span class=apple-converted-space> </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 class=apple-converted-space> </span><a
href="mailto:manueldarveau@gmail.com">manueldarveau@gmail.com</a><span
class=apple-converted-space> </span>sent:</b><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";
color:black'>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/">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 class=apple-converted-space> </span></a><a
href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span>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])})))' SELECT NON EMPTY
Hierarchize(Intersect({DrilldownLevel({[Subscription].[All Subscriptions]})},
[XL_Row_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM
[Rentals] WHERE ([Measures].[RentalsCount]) CELL PROPERTIES VALUE<br>
<span
class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span>Multidimensional<br>
<span
class=apple-converted-space> </span>TupleFormat<br>
<span
class=apple-converted-space> </span>Provider=Mondrian;DataSource=bixicube;<br>
<span
class=apple-converted-space> </span>1033<br>
<span
class=apple-converted-space> </span>bixicube<br>
<span
class=apple-converted-space> </span>1<br>
<span
class=apple-converted-space> </span><br>
<span
class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </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>
at
mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1695)<br>
at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:642)<br>
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:552)<br>
at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:411)<br>
at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:311)<br>
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)<br>
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<br>
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)<br>
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)<br>
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)<br>
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)<br>
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)<br>
at org.mortbay.jetty.Server.handle(Server.java:326)<br>
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)<br>
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)<br>
at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)<br>
at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)<br>
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)<br>
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)<br>
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>
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816)<br>
at mondrian.olap.Util.newInternal(Util.java:1492)<br>
at mondrian.olap.Util.newError(Util.java:1508)<br>
at
mondrian.rolap.RolapConnection.execute(RolapConnection.java:633)<br>
at
mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1691)<br>
... 19 more<br>
Caused by: java.lang.UnsupportedOperationException<br>
at mondrian.olap.fun.VisualTotalsFunDef$VisualTotalMember.getOrdinal(VisualTotalsFunDef.java:246)<br>
at
mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1854)<br>
at
mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1806)<br>
at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:2841)<br>
at
mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:2834)<br>
at java.util.Arrays.mergeSort(Arrays.java:1270)<br>
at java.util.Arrays.sort(Arrays.java:1210)<br>
at java.util.Collections.sort(Collections.java:159)<br>
at
mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:735)<br>
at
mondrian.olap.fun.HierarchizeFunDef$1.evaluateMemberList(HierarchizeFunDef.java:56)<br>
at
mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:569)<br>
at
mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)<br>
at
mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731)<br>
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574)<br>
at
mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540)<br>
at mondrian.rolap.RolapResult.(RolapResult.java:273)<br>
at
mondrian.rolap.RolapConnection.execute(RolapConnection.java:604)<br>
... 20 more<br>
02.05;09:41:58.653 DEBUG XML/A response content<br>
<br>
</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'><ns0:envelope
ns1:schemas.xmlsoap.org="" ns1:soap="" ns1:envelope="" ns1:target="_blank"><span
style='color:black'><a href="http://schemas.xmlsoap.org/soap/envelope/">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>"
><br>
</span><ns0:header><span style='color:black'><br>
<br>
</span><ns0:body><span style='color:black'><br>
</span><ns0:fault><span style='color:black'><br>
<span class=apple-converted-space> </span>SOAP-ENV:Server.00HSBD02<br>
<span class=apple-converted-space> </span>XMLA MDX execute failed<br>
<span class=apple-converted-space> </span>Mondrian<br>
<span class=apple-converted-space> </span><br>
<span class=apple-converted-space> </span></span><ns0:error
ns1:mondrian.sourceforge.net="" ns1:target="_blank"><span
style='color:black'><a href="http://mondrian.sourceforge.net">http://mondrian.sourceforge.net</a>"><br>
<span class=apple-converted-space> </span></span><code><span
style='font-size:10.0pt;color:black'>00HSBD02</span></code><span
style='color:black'><br>
<span class=apple-converted-space> </span>The
Mondrian XML: java.lang.UnsupportedOperationException<br>
<span class=apple-converted-space> </span></span><span
class=apple-converted-space></ns0:error></span><span style='color:black'><br>
<span class=apple-converted-space> </span><br>
</span></ns0:fault><span style='color:black'><br>
</span></ns0:body><span style='color:black'><br>
</span></ns0:header><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 class=apple-converted-space> </span><a
href="http://jira.pentaho.com/browse/MONDRIAN-295" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-295</a><span
class=apple-converted-space> </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></ns0:envelope><span style='color:black'><o:p></o:p></span></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";
color:black'><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">http://lists.pentaho.org/mailman/listinfo/mondrian</a><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'>Calum Miller<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'>Business Intelligence Specialist<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'><a href="mailto:calum@millersoft.ltd.uk">calum@millersoft.ltd.uk</a><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'><a href="http://www.millersoft.ltd.uk">http://www.millersoft.ltd.uk</a><o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'>Telephone: +44 (0) 131 208 0202<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'>Mobile: +44 (0) 7973 249 621<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'>Skype: calummiller<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";
color:black'><br>
<img border=0 width=300 height=82 id="_x0000_i1025"
src="cid:image001.jpg@01CAA687.9B9A0AC0"><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>