<!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=950305615-05042011><FONT color=#000080 size=2
face="Lucida Sans">The cache control API only affects cells. That is by
design.</FONT></SPAN></DIV>
<DIV><SPAN class=950305615-05042011><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=950305615-05042011><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"><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 class=950305615-05042011><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=950305615-05042011><FONT color=#000080 size=2
face="Lucida Sans">Julian</FONT></SPAN></DIV>
<DIV><SPAN class=950305615-05042011><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 class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <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>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" class=Apple-tab-span></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" class=Apple-tab-span></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" class=Apple-tab-span></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></BLOCKQUOTE></BODY></HTML>