Hi Julian,<div> I tried setting the mondrian.properties configuration <meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="font-family: monospace; font-size: 10px; line-height: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><a href="http://mondrian.pentaho.com/api/mondrian/olap/MondrianProperties.html#EnableRolapCubeMemberCache">mondrian.rolap.EnableRolapCubeMemberCache</a> to false and tried using the MemberEditCommand, I created a deletecommand and tried to execute it, it throws an NPE. It does not seem to work. Is there any test available which i can run to verify if this feature works?</span></div>
<div><font class="Apple-style-span" face="monospace" size="1"><span class="Apple-style-span" style="line-height: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><br></span></font></div>
<div><font class="Apple-style-span" face="monospace" size="1"><span class="Apple-style-span" style="line-height: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Thanks,</span></font></div>
<div><font class="Apple-style-span" face="monospace" size="1"><span class="Apple-style-span" style="line-height: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Venki<br></span></font><br>
<div class="gmail_quote">On Tue, Apr 5, 2011 at 9:35 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div><span><font color="#000080" size="2" face="Lucida Sans">The cache control API only affects cells. That is by
design.</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span><font color="#000080" size="2" face="Lucida Sans">There are is some beta functionality to flush members of
dimensions. See <a href="http://mondrian.pentaho.com/api/mondrian/olap/CacheControl.html" target="_blank"><font size="3" face="Times New Roman">http://mondrian.pentaho.com/api/mondrian/olap/CacheControl.html</font></a>,
in particular methods involving MemberEditCommand and
MemberSet.</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span><font color="#000080" size="2" face="Lucida Sans">Julian</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div><font color="#000080" size="2" face="Lucida Sans"></font><br>
<blockquote style="border-left:#000080 2px solid;padding-left:5px;margin-left:5px;margin-right:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b> <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>] <b>On Behalf Of </b>Venkatesh
U<br><b>Sent:</b> Tuesday, April 05, 2011 3:06 AM<br><b>To:</b> Mondrian
developer mailing list<br><b>Subject:</b> [Mondrian] Flush(Cube) does not
flush the Evaluated members like.Members and .Children<br></font><br></div><div><div></div><div class="h5">
<div></div>Hi All,
<div> I have a situation, where after flushing a Cube through cache
control API, the cube's data does get flushed. But the members of Evaluated
functions like [Level].Members and [Level].Children does not get flushed.
Please see the below log, I am able to get the value for the newly inserted
dimension value [D1_4], when accessed through absolute reference, but
[D1].Members does not include the newly added value [D1_4], though the cube is
flushed.</div>
<div><br></div>
<div>Attachment:Caching.zip contains simple java file I used for testing, log
file output, Schema file, mondrian.properties and log4j properties</div>
<div><br></div>
<div>The scenario is</div>
<div>1. Dimension tables get added with new values.</div>
<div>2. Flush the cube through flush(Cube) API</div>
<div><br></div>
<div>Below is what happens</div>
<div><br></div>
<div>
<div>1. Before Flushing:</div>
<div><span style="white-space:pre-wrap"></span>Mdx
QuerySELECT [Measures].[Value] ON COLUMNS,</div>
<div> {[D1].Members} on 1</div>
<div>FROM [testCube]</div>
<div> Value</div>
<div>======= ==== =======</div>
<div>All D1s 264,600</div>
<div> D1_1 10,800</div>
<div> D1_2 243,000</div>
<div> D1_3 10,800</div>
<div> </div>
<div>Inserted a row in TEST_DIM_1:sql:insert into TEST_DIM_1
values(4,'D1_4')</div>
<div>Inserted a row in TEST_FACT sql:insert into TEST_FACT
values(4,3,3,900)</div>
<div>Commited the changed to DB</div>
<div><br></div>
<div>2. After Flushing:</div>
<div><span style="white-space:pre-wrap"></span>Mdx
QuerySELECT [Measures].[Value] ON COLUMNS,</div>
<div> {[D1].Members} on 1</div>
<div>FROM [testCube]</div>
<div> Value</div>
<div>======= ==== =======</div>
<div>All D1s 265,500</div>
<div> D1_1 10,800</div>
<div> D1_2 243,000</div>
<div> D1_3 10,800</div>
<div><br></div>
<div>3. After Flushing:</div>
<div><span style="white-space:pre-wrap"></span>Mdx
QuerySELECT {[D1].[D1_4]} on 0</div>
<div>FROM [testCube]</div>
<div>mondrian.rolap.RolapAllCubeMember</div>
<div>D1_4</div>
<div>====</div>
<div> 900</div></div>
<div><br></div></div></div></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></div>