[Mondrian] Help with Cache Clean

Pedro Vale pedro.vale at webdetails.pt
Tue Mar 13 08:54:30 EDT 2012


Hi.

We're using some of the Cache APIS on Mondrian 3.4 and we're watching some unexpected (at least for us :) ) behavior.

Specifically, running the MDX query 

select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
  NON EMPTY {[Markets].[All Markets]} ON ROWS
from [SteelWheelsSales]

creates three cache entries, with the following headers:

Schema:[SteelWheels]
Checksum:[628cde503ee1fc734e229b4e27388c4a]
Cube:[SteelWheelsSales]
Measure:[Quantity]
Axes:[
    {CUSTOMER_W_TER.TERRITORY=(*)}]
Excluded Regions:[]
Compound Predicates:[]
ID:[030093e1d8e995f7c99b8f099955410a9f0cd56a5ab83d16c9ab25e7175a4ad5]

Schema:[SteelWheels]
Checksum:[628cde503ee1fc734e229b4e27388c4a]
Cube:[SteelWheelsSales]
Measure:[Quantity]
Axes:[]
Excluded Regions:[]
Compound Predicates:[]
ID:[e20b8d6a025ba7264550711770bcc3685e0d389b38e8513a5ca15cdb4d27adae]

Schema:[SteelWheels]
Checksum:[628cde503ee1fc734e229b4e27388c4a]
Cube:[SteelWheelsSales]
Measure:[Quantity]
Axes:[
    {DIM_TIME.YEAR_ID=(*)}]
Excluded Regions:[]
Compound Predicates:[]
ID:[e620e549193b8e6965b839db55f69674bbc965c698d60f3ff4bafa49a5d2bfdd]


However, when we try to clean the dimension Customers using the following code (for all hierarchies in the Dimension): 

                  CacheControl.CellRegion hierarchyRegion = cacheControl.createMemberRegion(hierarchies[k].getAllMember(), true);
                  CacheControl.CellRegion region = cacheControl.createCrossjoinRegion(cubeRegion, hierarchyRegion);
                  cacheControl.flush(region);

no items seem to be removed from the cache.
Flushing the entire cube using

        CellRegion cubeRegion = cacheControl.createMeasuresRegion(cubes[i]);
        cacheControl.flush(cubeRegion);

has the same result.

Is this the expected behavior? I also tried to clean the Member Cache (using MemberSet instead of CellRegion) but the results were the same.

We're using mondrian 3.4.0 Snapshot (build #1347 or 1348 from 07 March).


thanks for any help you can give us,

Pedro Vale                             pedro.vale at webdetails.pt
WebDetails Consulting                    http://www.webdetails.pt




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20120313/aa40d45b/attachment.html 


More information about the Mondrian mailing list