<!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>
<DIV><SPAN class=231060319-05022010><FONT color=#000080 size=2
face="Lucida Sans">That 'UnsupportedOperationException: getOrdinal' error
clearly indicates that this is <A
href="http://jira.pentaho.com/browse/MONDRIAN-678"><FONT size=3
face="Times New Roman">http://jira.pentaho.com/browse/MONDRIAN-678</FONT></A>.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<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>Manuel
Darveau<BR><B>Sent:</B> Friday, February 05, 2010 6:55 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Dimension filter and Excel
+ Simba O2X<BR></FONT><BR></DIV>
<DIV></DIV>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><?xml version="1.0"
encoding="UTF-8"?><Envelope xmlns="<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">http://www.w3.org/2001/XMLSchema</A>"
xmlns:xsi="<A
href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</A>"><BR>
<Header><BR> <Session
xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId=""
mustUnderstand="1"/><BR>
</Header><BR>
<Body><BR> <Execute
xmlns="urn:schemas-microsoft-com:xml-analysis"><BR>
<Command><BR>
<Statement>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</Statement><BR>
</Command><BR>
<Properties><BR>
<PropertyList><BR>
<Format>Multidimensional</Format><BR>
<AxisFormat>TupleFormat</AxisFormat><BR>
<DataSourceInfo>Provider=Mondrian;DataSource=bixicube;</DataSourceInfo><BR>
<LocaleIdentifier>1033</LocaleIdentifier><BR>
<Catalog>bixicube</Catalog><BR>
<VisualMode>1</VisualMode><BR>
</PropertyList><BR>
</Properties><BR>
</Execute><BR>
</Body><BR></Envelope><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.<init>(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><?xml
version="1.0" encoding="ISO-8859-1"?><BR><SOAP-ENV:Envelope
xmlns:SOAP-ENV="<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/">http://schemas.xmlsoap.org/soap/encoding/</A>"
><BR><SOAP-ENV:Header><BR><Session SessionId=""
xmlns="urn:schemas-microsoft-com:xml-analysis"
/></SOAP-ENV:Header><BR><SOAP-ENV:Body><BR><SOAP-ENV:Fault><BR>
<faultcode>SOAP-ENV:Server.00HSBD02</faultcode><BR>
<faultstring>XMLA MDX execute failed</faultstring><BR>
<faultactor>Mondrian</faultactor><BR>
<detail><BR> <XA:error xmlns:XA="<A
href="http://mondrian.sourceforge.net">http://mondrian.sourceforge.net</A>"><BR>
<code>00HSBD02</code><BR>
<desc>The Mondrian XML:
java.lang.UnsupportedOperationException</desc><BR>
</XA:error><BR>
</detail><BR></SOAP-ENV:Fault><BR></SOAP-ENV:Body><BR></SOAP-ENV:Envelope><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 <A
href="http://jira.pentaho.com/browse/MONDRIAN-295">http://jira.pentaho.com/browse/MONDRIAN-295</A>
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></BLOCKQUOTE></BODY></HTML>