Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: [Mondrian] Clean cache for a specific cube

  1. #1
    Pedro Alves Guest

    Default [Mondrian] Clean cache for a specific cube

    Hey there.


    I've mostly been cleaning my mondrian cache on a daily basis, but
    there's a particular cube (or schema) who's etl will run hourly.


    How can I clean the cache for that cube only?


    Thanks

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Luc Boudreau Guest

    Default Re: [Mondrian] Clean cache for a specific cube

    Pedro,

    I suggest reading the Mondrian Cache Control docs.

    http://mondrian.pentaho.com/document...he_control.php

    Here's an example.

    Connection connection;
    CacheControl cacheControl = connection.getCacheControl(null);
    for (Cube cube : connection.getSchema().getCubes()) {
    cacheControl.flush(
    cacheControl.createMeasuresRegion(cube));
    }

    Cheers!

    Luc


    On Wed, Feb 9, 2011 at 10:45 AM, Pedro Alves <pmgalves (AT) gmail (DOT) com> wrote:

    >
    >
    > Hey there.
    >
    >
    > I've mostly been cleaning my mondrian cache on a daily basis, but there's a
    > particular cube (or schema) who's etl will run hourly.
    >
    >
    > How can I clean the cache for that cube only?
    >
    >
    > Thanks
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Paul Stoellberger Guest

    Default Re: [Mondrian] Clean cache for a specific cube

    I was looking at that code but I'm a bit confused...
    if you call cacheControl.flush(CellRegion) it will only normalize and call flushNonUnion(cellRegion); ...and that one will throw an Exception

    So where exactly is the cache flushed?

    I can see the Test Cases, I just don't quite understand how it works

    -Paul


    On Feb 9, 2011, at 15:48 , Luc Boudreau wrote:

    > Pedro,
    >
    > I suggest reading the Mondrian Cache Control docs.
    >
    > http://mondrian.pentaho.com/document...he_control.php
    >
    > Here's an example.
    >
    > Connection connection;
    > CacheControl cacheControl = connection.getCacheControl(null);
    > for (Cube cube : connection.getSchema().getCubes()) {
    > cacheControl.flush(
    > cacheControl.createMeasuresRegion(cube));
    > }
    >
    > Cheers!
    >
    > Luc
    >
    >
    > On Wed, Feb 9, 2011 at 10:45 AM, Pedro Alves <pmgalves (AT) gmail (DOT) com> wrote:
    >
    >
    > Hey there.
    >
    >
    > I've mostly been cleaning my mondrian cache on a daily basis, but there's a particular cube (or schema) who's etl will run hourly.
    >
    >
    > How can I clean the cache for that cube only?
    >
    >
    > Thanks
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.