<!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.6001.17052" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Verdana color=#000080
size=2></FONT> </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>Agustin
Campos<BR><B>Sent:</B> Monday, February 04, 2008 8:54 AM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> [Mondrian]
cache<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hello all!<BR><BR>I've been looking for some help about Mondrian cache.
<BR>I've found two pages, both have allmost the same: <BR><BR>- <A
href="http://mondrian.pentaho.org/documentation/cache_control.php">http://mondrian.pentaho.org/documentation/cache_control.php</A><BR><BR>-
<A
href="http://julianhyde.blogspot.com/2007/02/mondrian-cache-control.html">http://julianhyde.blogspot.com/2007/02/mondrian-cache-control.html</A><BR><BR>The
case is that I don't know where do you define "cacheControl" (case sensitive)
in them. It appears "CacheControl" (see the capital 'C'). <SPAN
class=268324803-05022008><FONT face=Verdana color=#000080
size=2> </FONT></SPAN></DIV></BLOCKQUOTE>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2>Sorry, I should have made that clearer in the examples. I'll fix the
cache_control.php doc next release.</FONT></SPAN></DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2>Connection connection;</FONT></SPAN></DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2>CacheControl cacheControl =
connection.getCacheControl(null);</FONT></SPAN></DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080 size=2>See
<A
href="http://mondrian.pentaho.org/api/mondrian/olap/Connection.html#getCacheControl(java.io.PrintWriter">http://mondrian.pentaho.org/api/mondrian/olap/Connection.html#getCacheControl(java.io.PrintWriter)</A></FONT></SPAN></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV>I have more problems, because my cube will be either in English or
Spanish depending on a locale variable. <BR><BR>How could I use those examples
to be able to delete the ENTIRE cache?<BR>I know It would make the system work
a lot, but I don't find anything more easiest or fastest to achiefe this
issue. <BR><SPAN class=268324803-05022008><FONT face=Verdana
color=#000080 size=2> </FONT></SPAN></DIV></BLOCKQUOTE>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2>CacheControl.createMeasuresRegion creates a region representing all facts
in an entire cube - I don't think there's a shorthand way to flush all cubes in
a schema.</FONT></SPAN></DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080 size=2>Note
that mondrian maintains a cache for each schema (URI from which it has read a
catalog file). If you have multiple schemas in your server, you may wish to call
CacheControl.flushSchemaCache(). This will allow mondrian to forget the cache
for any schemas not being actively used.</FONT></SPAN></DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=268324803-05022008><FONT face=Verdana color=#000080
size=2>Julian</FONT></SPAN></DIV></BODY></HTML>