<!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=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans">I presume because Cache is introduced as a physical
optimization and the query has the same semantics if it is not
present.</FONT></SPAN></DIV>
<DIV><SPAN class=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans">The planner introduces Cache in certain circumstances such as
directly under a Rank function. Maybe the planner is not smart enough to not
introduce it twice.</FONT></SPAN></DIV>
<DIV><SPAN class=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans">Because of these issues, I'd rather that these kind of
optimizations didn't modify the MDX parse tree at all. In other words, Cache
shouldn't be a function, it should be a Calc. But it is what it
is.</FONT></SPAN></DIV>
<DIV><SPAN class=963031119-05022010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=963031119-05022010><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>Matt
Campbell<BR><B>Sent:</B> Thursday, February 04, 2010 12:25 PM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> [Mondrian]
CacheFunDef.unparse()<BR></FONT><BR></DIV>
<DIV></DIV><BR>CacheFunDef has an override for unparse which has the effect of
suppressing the function from the unparsed output. Does anyone know the
rationale for this behavior?<BR><BR></BLOCKQUOTE></BODY></HTML>