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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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>