<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2>Haridasan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2>CachePool is now
mondrian.rolap.cache.CachePool.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=097291420-14042007><FONT face=Verdana
color=#000080 size=2>PS Please don't log your problems in reply to utterly
unrelated email threads. It makes it confusing for people browsing the
archives.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Haridasan
T<BR><B>Sent:</B> Saturday, April 14, 2007 10:42 AM<BR><B>To:</B> Mondrian
developer mailing list<BR><B>Subject:</B> Re: [Mondrian] RE: Generic IIF
implementation for your review<BR></FONT><BR></DIV>
<DIV></DIV><FONT size=2><FONT face=Tahoma></FONT> </FONT>
<P>Not able to flush Cache.</P>
<P><FONT face=Verdana color=#000080 size=2></FONT> </P>
<P>Giving error</P>
<H2><FONT size=2>javax.servlet.ServletException:
javax.servlet.jsp.JspException: Unable to compile class for JSP An error
occurred at line: 10 in the jsp file: /WEB-INF/queries/ar.jsp Generated
servlet error: mondrian.rolap.CachePool cannot be resolved to a type
</FONT></H2><PRE>javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to compile class for JSP
An error occurred at line: 10 in the jsp file: /WEB-INF/queries/ar.jsp
Generated servlet error:
mondrian.rolap.CachePool cannot be resolved to a type</PRE>
<P>---</P>
<P>se code below</P>
<P>---</P>
<P><FONT color=red><%@ page </FONT><FONT face="Courier New" color=red
size=2>import="mondrian.olap.*;</FONT><FONT size=2><FONT color=red>"
%></FONT></FONT></P>
<P><%@ page session="true" contentType="text/html; charset=ISO-8859-1"
%></P>
<P><%@ taglib uri="<A
href="http://www.tonbeller.com/jpivot">http://www.tonbeller.com/jpivot</A>"
prefix="jp" %></P>
<P><%@ taglib prefix="c" uri="<A
href="http://java.sun.com/jstl/core">http://java.sun.com/jstl/core</A>"
%></P>
<P><FONT face=Verdana color=#000080 size=2></FONT> </P>
<P><FONT face=Verdana color=#000080 size=2></FONT> </P>
<P><FONT face=Verdana color=#000080 size=2></FONT> </P>
<P><FONT color=red><%</FONT></P>
<P><FONT color=red>mondrian.rolap.CachePool.flush();</FONT></P>
<P><FONT color=red>%></FONT></P>
<P> </P>
<P><jp:mondrianQuery id="query01"
jdbcDriver="oracle.jdbc.driver.OracleDriver"
jdbcUrl="jdbc:oracle:thin:@localhost:1521:XE " jdbcUser="ABCD"
jdbcPassword="ABCD" </P>
<P>catalogUri="/WEB-INF/queries/ar.xml"></P>
<P> </P>
<P> </P>
<P>select {
[Measures].[Outstanding],[Measures].[Days_60],[Measures].[Days_90],[Measures].[Days_120],[Measures].[Over_120]}
on columns,NON EMPTY</P>
<P>{([Country].[All country],[Location].[All location],[Area].[All
area],[Customer].[All customer])} on rows</P>
<P>from ar</P>
<P></jp:mondrianQuery></P>
<P><c:set var="title01" scope="session">TEST-2s </c:set></P>
<P> </P>
<P> </P><BR><BR>
<DIV><SPAN class=gmail_quote>On 4/12/07, <B class=gmail_sendername>Julian
Hyde</B> <<A
href="mailto:julianhyde@speakeasy.net">julianhyde@speakeasy.net</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>I'm
not against introducing variant values into mondrian, but the impact of this
change might be insidious, because we're blowing a hole in the strong typing
system. Once a variant is introduced, it needs to work correctly in any
expression. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2>Consider these examples:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>1.
</FONT></SPAN><SPAN><FONT face=Verdana color=#000080 size=2>Iif(1 = 1, 2, 3)
+ 4</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>2.
</FONT></SPAN><SPAN><FONT face=Verdana color=#000080 size=2>Iif(1 = 1,
"Foo", 3) + 4</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>In
each case, what do you expect to happen, and what actually
happens?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>#1
currently type-checks as an integer expression, but after your change it
will be <variant> + <int>, and I'm not sure how that gets
type-checked or evaluated. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>#2
currently gives a compile-time exception, which can be fixed using
casts:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>Iif(1
= 1, "Foo", Cast(3 as string)) + Cast(4 as string)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>So, a
simpler solution might be to fix the type inference/validation of the Iif
function. Require the arguments to be of the same type (using 'cast' if
necessary), make sure that we give a useful error message if the arguments
are of incompatible types, and make Iif return the same type as its 2nd and
3rd arguments. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>Note
that everything which applies to Iif probably applies to CASE
also.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2>Julian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Verdana color=#000080 size=2>PS
Please send future emails to the mondrian dev list unless they contain
proprietary/sensitive material.</FONT></SPAN></DIV><FONT face=Verdana
color=#000080 size=2></FONT><FONT face=Verdana color=#000080
size=2></FONT><FONT face=Verdana color=#000080 size=2></FONT><FONT
face=Verdana color=#000080 size=2></FONT><FONT face=Verdana color=#000080
size=2></FONT><FONT face=Verdana color=#000080 size=2></FONT><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma size=2><B>From:</B> Thiyagu Palanisamy [mailto:<A
href="mailto:tpalanis@thoughtworks.com"
target=_blank>tpalanis@thoughtworks.com</A>] <BR><B>Sent:</B> Tuesday,
April 10, 2007 6:39 AM<BR><B>To:</B> <A
href="mailto:julianhyde@speakeasy.net"
target=_blank>julianhyde@speakeasy.net</A><BR><B>Cc:</B> <A
href="mailto:Matthew.Campbell@thomson.com"
target=_blank>Matthew.Campbell@thomson.com</A>; Ajit Vasudeo Joglekar; <A
href="mailto:RenoMondrian@thoughtworks.com"
target=_blank>RenoMondrian@thoughtworks.com</A><BR><B>Subject:</B> Generic
IIF implementation for your review<BR></FONT><BR> </DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi Julian,</FONT>
<BR><BR><FONT face=sans-serif size=2>We have come up with a solution to
make IIf MDX function to take (boolean, variant, variant) and return a
(variant) similar to MSAS so as to avoid all permutations and combinations
of parameter types and different return types decided at run time.
</FONT><BR><BR><FONT face=sans-serif size=2>We realized that currently
there is no support for BasicType or AnyType or VariantType that we can
readily use. We were looking for late binding support rather than the
current early binding (compilation) that takes place. We initially
thought of a base class to all the specific Type classes but realized that
there could be substantial changes and still no guarantee of making it
work. Then we thought of adding just another Type (VariantType) and
providing special handling for it where ever required.
</FONT><BR><BR><FONT face=sans-serif size=2>We have been able to
successfully run all tests with this generic IIf.</FONT> <BR><BR><FONT
face=sans-serif size=2>We have attached the zip file containing all the
modified files. Files are based on revision no : 9071 (Couldn't get
packChange to work in our machine) </FONT><BR><BR><FONT face=sans-serif
size=2>Extracting the attached archive in /home/open will copy and replace
the modified files.</FONT> <BR><BR><BR><BR><BR><FONT face=sans-serif
size=2>We have not checked in into perforce because of few fundamental
changes that we feel should be reviewed first. Could you please review
this? </FONT><BR><BR><FONT face=sans-serif size=2>Thanks &
Regards,</FONT> <BR><FONT face=sans-serif size=2>Ajit &Thiyagu -
Pairing</FONT>
<BR></BLOCKQUOTE></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 clear=all><BR>-- <BR><A
href="http://cfo-portal.blogspot.com/">http://cfo-portal.blogspot.com/</A>
</BLOCKQUOTE></BODY></HTML>