<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019"></HEAD>
<BODY>
<DIV><SPAN class=407314417-05042011><FONT color=#000080 size=2
face="Lucida Sans">See MemberCacheControlTest.</FONT></SPAN></DIV><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 class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Venkatesh U
[mailto:venkatesh20@gmail.com] <BR><B>Sent:</B> Tuesday, April 05, 2011 10:17
AM<BR><B>To:</B> jhyde@pentaho.com; Mondrian developer mailing
list<BR><B>Subject:</B> Re: [Mondrian] Flush(Cube) does not flush the
Evaluated members like.Members and .Children<BR></FONT><BR></DIV>
<DIV></DIV>Hi Julian,
<DIV> I tried setting the mondrian.properties configuration <SPAN
style="LINE-HEIGHT: 18px; FONT-FAMILY: monospace; FONT-SIZE: 10px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"
class=Apple-style-span><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 size=1 face=monospace><SPAN
style="LINE-HEIGHT: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"
class=Apple-style-span><BR></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=1 face=monospace><SPAN
style="LINE-HEIGHT: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"
class=Apple-style-span>Thanks,</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=1 face=monospace><SPAN
style="LINE-HEIGHT: 18px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"
class=Apple-style-span>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
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<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></BLOCKQUOTE></BODY></HTML>