<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=328222916-17042009><FONT face="Lucida Sans" color=#000080
size=2>That forum post is based on a blog entry that I wrote while I was
implementing the cache control API. </FONT></SPAN><SPAN
class=328222916-17042009><FONT face="Lucida Sans" color=#000080 size=2>Cache
control is now in mondrian's official documentation: <A
href="http://mondrian.pentaho.org/documentation/cache_control.php"><FONT
face="Times New Roman"
size=3>http://mondrian.pentaho.org/documentation/cache_control.php</FONT></A></FONT></SPAN></DIV>
<DIV><FONT face="Lucida Sans" color=#000080 size=2></FONT> </DIV>
<DIV><SPAN class=328222916-17042009><FONT face="Lucida Sans" color=#000080
size=2>Recently we added some experimental methods to the CacheControl API to
control the dimension cache, for example </FONT><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 16px 'times new roman'; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0"></DIV><PRE><FONT face="Lucida Sans" color=#000080 size=2>void </FONT><A href="outbind://20/src-html/mondrian/olap/CacheControl.html#line.261"><B><FONT face="Lucida Sans" color=#000080 size=2>execute</FONT></B></A><FONT face="Lucida Sans" color=#000080 size=2>(</FONT><A title="interface in mondrian.olap" href="outbind://20/mondrian/olap/CacheControl.MemberEditCommand.html"><FONT face="Lucida Sans" color=#000080 size=2>CacheControl.MemberEditCommand</FONT></A><FONT face="Lucida Sans" color=#000080 size=2> cmd)</FONT></PRE>
<DIV></SPAN><FONT color=#000080><FONT face="Lucida Sans"><FONT size=2>Lastly,
there is the schema cache. <SPAN class=328222916-17042009>This is probably
what you are interested in here. </SPAN>That is the policy that determines
whether mondrian should re-read the schema.xml file when a new connection is
established, or whether it should share metadata with existing connections that
use the same schema URI.<SPAN class=328222916-17042009> See <A
href="http://mondrian.pentaho.org/documentation/configuration.php#Schema_cache">http://mondrian.pentaho.org/documentation/configuration.php#Schema_cache</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Lucida Sans" color=#000080 size=2></FONT> </DIV>
<DIV></SPAN><SPAN class=328222916-17042009><FONT face="Lucida Sans"
color=#000080 size=2>Julian</FONT></SPAN></DIV>
<DIV><FONT face="Lucida Sans" color=#000080 size=2></FONT><BR></DIV>
<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>Diego
Dimunzio<BR><B>Sent:</B> Friday, April 17, 2009 5:47 AM<BR><B>To:</B> Mondrian
developer mailing list<BR><B>Subject:</B> Re: [Mondrian] Presentation and
doubt<BR></FONT><BR></DIV>
<DIV></DIV>Hello Javier,<BR>I far I know it's normal even when you flush the
mondrian cache by hand, there is no wait to clear the dimension cache.<BR>Here
is a good post about it.<BR><A
href="http://forums.pentaho.org/archive/index.php/t-51518.html">http://forums.pentaho.org/archive/index.php/t-51518.html</A><BR><BR>Regards<BR>Diego<BR><BR>
<DIV class=gmail_quote>On Fri, Apr 17, 2009 at 8:25 AM, Javier Chávez B. <SPAN
dir=ltr><<A
href="mailto:jchavezb@gmail.com">jchavezb@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><BR><BR>
<DIV class=gmail_quote>
<DIV class=im>On Fri, Apr 17, 2009 at 1:56 AM, Ken Cheng <SPAN
dir=ltr><<A href="mailto:pubdevgroup@gmail.com"
target=_blank>pubdevgroup@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi
Javier,<BR> Seems your schema file is not a
well-formated xml file.<BR>change "<Table name="Categories">" to
'<Table name="Categories"/>" and have a try<BR></BLOCKQUOTE></DIV>
<DIV><BR>Thanks to all for your councils ... already have my little
cube running :0) .. the principal problem was the cache refresh .. so any
time that change my XML i've to restart my Tomcat ... is this
normal??<BR><BR>Best Regard.<BR><BR>Javier.<BR><BR><BR><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><BR>Sherman
Wood wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV></DIV>
<DIV><BR>You need to add a Level to the
Hierarchy.<BR><BR> <BR>Sherman<BR><BR> <BR>*From:* <A
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A> [mailto:<A
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A>] *On Behalf Of *Javier
Chávez B.<BR>*Sent:* Thursday, April 16, 2009 8:58 AM<BR>*To:* <A
href="mailto:mondrian@pentaho.org"
target=_blank>mondrian@pentaho.org</A><BR>*Subject:* [Mondrian]
Presentation and doubt<BR><BR> <BR>Hi all.. sorry for my english
but i'm learning :0)<BR><BR>Dear all i need some orientation about a
cube that i'm trying to do...<BR><BR>i've made an MDX with the structure
as follow:<BR><BR><Schema name="Cubo" ><BR> <Cube
name="Cubo" cache="true" enabled="true"><BR>
<Table name="Payment_Worker" alias="Fact_Table"><BR>
</Table><BR>
<Dimension name="Category" foreignKey="Cat_Id"
><BR> <Hierarchy
hasAll="true" allMemberName="All Categories" primaryKey="Cat_Id"
defaultMember="All Categories"><BR>
<Table name="Categories"><BR>
</Hierarchy><BR>
</Dimension><BR> <Measure
name="Payment" column="paw_Totalpay" datatype="Numeric" aggregator="sum"
visible="true"><BR>
</Measure><BR>
</Cube><BR></Schema><BR><BR>also i've the next
Query :<BR><BR>select<BR> {[Measures].[Payment]} on
columns,<BR> {([Category].[All Categories])} ON rows<BR>from
Cubo<BR><BR>but when try to run this query i get the next
error:<BR><BR><BR> org.apache.jasper.JasperException:
javax.servlet.ServletException:<BR>
javax.servlet.jsp.JspException:
org.apache.jasper.JasperException:<BR>
javax.servlet.ServletException:
javax.servlet.jsp.JspException:<BR>
com.tonbeller.jpivot.olap.model.OlapException: Mondrian
Error:MDX<BR> object '[Category].[All Categories]' not found
in cube 'Cubo'<BR><BR>Somebody can help or orient about what i'm doing
wrong... sorry if the question is very basic !!!<BR><BR>Thanks in
advice.<BR><BR>Javier.<BR><BR>-- <BR>Cumprimentos<BR>jchavez<BR>linux
User #397972 on <A href="http://counter.li.org/"
target=_blank>http://counter.li.org/</A><BR><BR></DIV></DIV>Groucho Marx
<<A
href="http://www.brainyquote.com/quotes/authors/g/groucho_marx.html"
target=_blank>http://www.brainyquote.com/quotes/authors/g/groucho_marx.html</A>>
- "A child of five would understand this. Send someone to fetch a
child of
five."<BR><BR>------------------------------------------------------------------------
<DIV><BR><BR>_______________________________________________<BR>Mondrian
mailing list<BR><A href="mailto:Mondrian@pentaho.org"
target=_blank>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></DIV></BLOCKQUOTE>
<DIV>
<DIV></DIV>
<DIV><BR>_______________________________________________<BR>Mondrian
mailing list<BR><A href="mailto:Mondrian@pentaho.org"
target=_blank>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></DIV></DIV></BLOCKQUOTE></DIV></DIV></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5><BR><BR clear=all><BR>-- <BR>Cumprimentos<BR>jchavez<BR>linux
User #397972 on <A href="http://counter.li.org/"
target=_blank>http://counter.li.org/</A><BR><BR></DIV></DIV><A
href="http://www.brainyquote.com/quotes/authors/g/groucho_marx.html"
target=_blank>Groucho Marx</A> - "A child of five would understand
this. Send someone to fetch a child of five."
<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>Diego Andres Dimunzio<BR></BLOCKQUOTE></BODY></HTML>