<!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.18904"></HEAD>
<BODY>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans">It's Mondrian problem, not specific to
Excel.</FONT></SPAN></DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans">Mondrian is being truthful -- it can't know to roll up
averages. </FONT></SPAN><SPAN class=019102320-20052010><FONT color=#000080
size=2 face="Lucida Sans">If I tell you the average age of Male customers is 32
and the average age of Female customers is 28, what's the average age of all
customers? There's simply not enough information.</FONT></SPAN></DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans">However, if you replace your 'avg' measure with two stored
measures 'sum' and 'count', then create a calculated measure from these, you
will be able to roll up.</FONT></SPAN></DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans">There is a feature request to make mondrian smart enough to
do this automatically: <A
href="http://jira.pentaho.com/browse/MONDRIAN-675"><FONT size=3
face="Times New Roman">http://jira.pentaho.com/browse/MONDRIAN-675</FONT></A></FONT></SPAN></DIV>
<DIV><SPAN class=019102320-20052010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=019102320-20052010><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">
<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> Thursday, May 20, 2010 8:54 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Excel +
MondrianEvaluationException: Don't know how torollup aggregator
'avg'<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>I am using excel 2007 (+ simba O2X plugin) and connect
to mondrian via XMLA.<BR>Most queries are working perfectly (as far as
mondrian is concerned) but he's having a hard time with one particular type of
query.<BR><BR>I have a dimension with days of week (the dimension hierarchy is
year/month/day of week) and I would like to filter so only some day of weeks
are used. In excel, you can add a filter, check the "Select Multiple Items"
and select elements you need.<BR>If I query fact count, min, max, I don't have
any problem. If I query an avg dimension, I get the following
exception:<BR><BR>2010.05.20;11:38:49.892 WARN Mondrian: exception in
executeStripe.<BR>mondrian.olap.fun.MondrianEvaluationException: Don't know
how to rollup aggregator 'avg'<BR> at
mondrian.olap.fun.FunUtil.newEvalException(FunUtil.java:76)<BR>
at
mondrian.olap.fun.AggregateFunDef$AggregateCalc.aggregate(AggregateFunDef.java:99)<BR>
at
mondrian.olap.fun.AggregateFunDef$AggregateCalc.evaluate(AggregateFunDef.java:71)<BR>
at
mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:512)<BR>
at
mondrian.rolap.RolapResult.executeStripe(RolapResult.java:902)<BR>
at
mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1040)<BR>
at
mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1040)<BR>
at
mondrian.rolap.RolapResult.executeBody(RolapResult.java:798)<BR>
at
mondrian.rolap.RolapResult.<init>(RolapResult.java:416)<BR>
at
mondrian.rolap.RolapConnection.execute(RolapConnection.java:607)<BR>
at
mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1668)<BR>
at
mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:635)<BR>
at
mondrian.xmla.XmlaHandler.process(XmlaHandler.java:551)<BR>
at
mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:426)<BR>
at
mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:329)<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><BR>The
MDX query is:<BR>with member [Date.date_weekday].[XL_QZX] as
'Aggregate({[Date.date_weekday].[2010].[April].[Saturday],
[Date.date_weekday].[2010].[April].[Sunday]})'<BR>select NON EMPTY
Hierarchize({DrilldownLevel({[Time.TimeToQuarter].[All
Time.TimeToQuarters]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS<BR>from [Station]<BR>where ([Measures].[AverageFullPercent],
[Date.date_weekday].[XL_QZX])<BR><BR>I don't speak MDX fluently so can anybody
confirm that this is a mondrian or an excel problem?<BR><BR>I am using the
mondrian 3.2.0.13583 but I am willing to try nightly builds.<BR><BR>Thank you
very much, any help is greatly
appreciated!<BR><BR>Manuel<BR></BLOCKQUOTE></BODY></HTML>