<font size="2">
<div> </div>
<div>In the below case</div>
<div>
<p><% mondrian.rolap.RolapSchema.clearCache(); %> does not work with he 3.0 version of mondrian</p>
<p>How to clear Schema cache ?</p></div>
<div><%@ page session="true" contentType="text/html; charset=iso-8859-1" language="java"</div>
<p>import='java.sql.*, javax.sql.*,javax.naming.*'%></p>
<p> </p>
<p><%@ page import="mondrian.rolap.*;" %></p>
<p><% mondrian.rolap.RolapSchema.clearCache(); %></p>
<p></p>
<p> </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><jp:mondrianQuery id="query01" jdbcDriver="oracle.jdbc.driver.OracleDriver" jdbcUrl="jdbc:oracle:thin:@192.168.1.101:1521:orcl" jdbcUser="nikilive" jdbcPassword="nikilive" </p>
<p>catalogUri="/WEB-INF/queries/FV_ADJUSTMENT_BI.xml"></p>
<p>select NON EMPTY {[Measures].[Total Adjustments],[Measures].[Total Sales]} on columns, NON EMPTY </p>
<p>{([Company].[All Company],[Year].[All Year],[Customer].[All Customer])} ON rows from FV_ADJUSTMENT_BI</p>
<p></jp:mondrianQuery></p>
<p><c:set var="title01" scope="session"><%=result0%></c:set></p>
<p><%connection0.close();%></p></font>
<div> </div>
<div> </div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div> </div>
<div>Hari Nair</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/15/08, <b class="gmail_sendername">Julian Hyde</b> <<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</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">Test case?</font></span></div><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"><span class="q"><b>From:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Haridasan T<br>
</span><b>Sent:</b> Thursday, August 14, 2008 9:13 PM<span class="q"><br><b>To:</b> Mondrian developer mailing list<br></span>
<div><span class="e" id="q_11bc5034aad4591a_4"><b>Subject:</b> Re: [Mondrian] Dimension member caching<br></span></div></font><br> </div>
<div><span class="e" id="q_11bc5034aad4591a_6">
<div></div>
<div>rolap.clearcache does not work with 3.0 of mondrian</div>
<div>It used to work with older versions</div>
<div>How to clear the cache using 3.0 of mondrian</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/14/08, <b class="gmail_sendername"><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:michael.pflug@thomsonreuters.com" target="_blank">michael.pflug@thomsonreuters.com</a></b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:michael.pflug@thomsonreuters.com" target="_blank">michael.pflug@thomsonreuters.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" bgcolor="white" vlink="blue" link="blue">
<div>
<p><font face="Arial" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Arial">Thanks Mark. After some more discussion we agree that the best way to achieve our goal of never caching a dimension would not fall in line with 10788 because, as you pointed out, </span></font><font color="black"><span style="COLOR: windowtext">10788 is intended to minimize dimension table reads, not force them</span></font><font face="Arial" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Arial">. Our current thought is that we can implement a new method in the CacheControl API that takes a hierarchy, gets a MemberCacheHelper and calls MemberCacheHelper.flush() to flush the appropriate hierarchy. Does this sound like a valid solution? </span></font></p>
<p><font face="Arial" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Arial">Thanks,</span></font></p>
<p><font face="Arial" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Arial">Mike</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt; COLOR: windowtext">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" color="black" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: windowtext; FONT-FAMILY: Tahoma"> Marc Berkowitz [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:marcb52@speakeasy.net" target="_blank">marcb52@speakeasy.net</a>] <br>
<b><span style="FONT-WEIGHT: bold">Sent:</span></b> Saturday, August 09, 2008 12:25 AM<span><br><b><span style="FONT-WEIGHT: bold">To:</span></b> Mondrian developer mailing list<br></span><b><span style="FONT-WEIGHT: bold">Cc:</span></b> Pflug, Michael (TH USA)<span><br>
<b><span style="FONT-WEIGHT: bold">Subject:</span></b> Re: [Mondrian] Dimension member caching</span></span></font><font color="black"><span style="COLOR: windowtext"></span></font></p></div>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt">(I wrote this code -- and am still fixing it -- so I'll try to answer these questions.)<span><br><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:michael.pflug@thomsonreuters.com" target="_blank">michael.pflug@thomsonreuters.com</a> wrote: </span></span></font></p>
<span><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">I plan to utilize the dimension member caching feature implemented</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">with check in 10788 but I have a few questions I'm hoping the community</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">can help me out with before I get too far: </span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">1) The feature is dependant on having the property</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">mondrian.rolap.EnableRolapCubeMemberCache=false, but I don't fully</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">understand the consequences of setting this property to false. Can</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">anyone elaborate? </span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre></span>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt">This is a tricky point; my own understanding may be warped, but I see it like this:<br>Usually a schema defines dimension members by referring to a dimension table. Mondrian creates a <i><span style="FONT-STYLE: italic">RolapMember</span></i> object when it is needed, reading its attributes from the dimension table. The resulting object is saved in a cache so it can be found again, avoiding reading from the table again. The cache also guarantees there is a unique <i><span style="FONT-STYLE: italic">RolapMember</span></i> for each member, and the cache has "indexes" to find related members (parent, children, level-peers) in constant time. It is a soft cache - unused members can be dropped from the cache for garbage collection -- <br>
and this is valid because should the member be needed again, it will just be read from the table and put again into the cache.<br><br>This design assumes that the dimension table doesn't change. My new feature helps deal with a dimension that changes in known small ways, letting an application edit selected items in the cache, or flush them from the cache to be reloaded with new values.<br>
<br>However, checkin 10203 of last november changed the cache design, introducing a two level cache. The goal was to deal with shared members in a shared dimension, used by several cubes. Now a member is represented by both a global <i><span style="FONT-STYLE: italic">RolapMember</span></i> (for all cubes) and a local <i><span style="FONT-STYLE: italic">RolapCubeMember</span></i> (one for each relevant cube). <br>
The cache structure is much more complicated -- so it seemed risky to alter it to add the new features. Therefore I implemented them to act on the simpler, single level member cache.<br>The property <i><span style="FONT-STYLE: italic">EnableRolapCubeMemberCache</span></i> was added so an application can choose the old one-level cache (which supports my cache edits), or the newer two-level cache<br>
(which does not, but offers the advantages of checkin 10203). I assume that 10203 pays off for shared dimensions, and has no advantage otherwise.<br><br><br></span></font></p><span><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">2) In the unit test MemberCacheControlTest.testDeleteCommand(), the</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">test allows two possible outcomes - one that flushes only the desired</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">member and one that flushes the entire level. Walking through the test</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">it always seems to flush the entire level which is arguably less</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">desirable. Does anyone understand this behavior? </span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre></span>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt">Flushing</span></font> more than requested is certainly sub-optimal, but strictly speaking it's not incorrect, since mondrian might flush the member cache spontaneously to reclaim space.<br>
<br></p><span><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">3) The code specifically does not allow flushing of parent-child</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">dimensions and, as luck would have it, the dimension I am most</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">interested in flushing is parent-child. There is no comment as to why</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">parent-child isn't allowed - can anyone fill me in on what the</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">difficultly might be in implementing this?</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre>
</span>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt">I avoided parent/child hierarchies because they have a more complex structure in the member cache. The existing design of member-cache edits might accommodate them, or it might require a complete rewrite. I'd have to try it and see. However I think a refactoring of the member cache is likely in the near term, so it seems easier and maybe faster to wait for that, rtsher than do a rewrite.<br>
<br></span></font></p><span><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt"> </span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">4) Finally, my specific use case is that I have a volatile dimension</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">that I wish never to be cached. I could clear the cache manually before</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">each query, but I'd rather specify an optional property in my schema</span></font></pre>
<pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">telling Mondrian to never cache the dimension. Does anyone have any</span></font></pre><pre><font face="Courier New" color="black" size="2"><span style="FONT-SIZE: 10pt">objections to that implementation</span></font></pre>
</span>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt">No, but that's a different goal to 10788, which is intended to minimize dimension table reads, not force them.<br>And it seems useful and (probably) simpler to implement than member-cache-edits!</span></font></p>
</div></div><br>_______________________________________________<br>Mondrian mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br></blockquote></div><br></span></div>
</blockquote></div><br>_______________________________________________<br>Mondrian mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>