[Mondrian] Flush(Cube) does not flush the Evaluated members like .Members and .Children

Venkatesh U venkatesh20 at gmail.com
Tue Apr 5 06:06:22 EDT 2011


Hi All,
  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.

Attachment:Caching.zip contains simple java file I used for testing, log
file output, Schema file, mondrian.properties and log4j properties

The scenario is
1. Dimension tables get added with new values.
2. Flush the cube through flush(Cube) API

Below is what happens

1. Before Flushing:
 Mdx QuerySELECT [Measures].[Value] ON COLUMNS,
 {[D1].Members} on 1
FROM [testCube]
             Value
======= ==== =======
All D1s      264,600
        D1_1  10,800
        D1_2 243,000
        D1_3  10,800

Inserted a row in TEST_DIM_1:sql:insert into TEST_DIM_1 values(4,'D1_4')
Inserted a row in TEST_FACT sql:insert into TEST_FACT values(4,3,3,900)
Commited the changed to DB

2. After Flushing:
 Mdx QuerySELECT [Measures].[Value] ON COLUMNS,
 {[D1].Members} on 1
FROM [testCube]
             Value
======= ==== =======
All D1s      265,500
        D1_1  10,800
        D1_2 243,000
        D1_3  10,800

3. After Flushing:
 Mdx QuerySELECT  {[D1].[D1_4]} on 0
FROM [testCube]
mondrian.rolap.RolapAllCubeMember
D1_4
====
 900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110405/018c9bbc/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: caching.zip
Type: application/zip
Size: 7732 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20110405/018c9bbc/attachment.zip 


More information about the Mondrian mailing list