Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: refresh cube

  1. #1
    Join Date
    Aug 2007
    Posts
    15

    Default refresh cube

    Hello,
    I use pentaho_demo-1.2.1.625-GA

    I make two portlets using Pentaho Cube designer.
    All work greate (I can lunch the xaction).
    (file deploy with the designer)

    My portlet use a SQL database to consum data. But when I insert other data in ma database, my portlet is not update. (if I lunch again the portlet, the result is the same).

    I think that, Pentaho use cache. But what can I do to clear this cache ?
    I would like to have an automatic method.
    For example, when my xaction is lunch, I would like to auto refresh the page every 10 minutes, for update the olap cube.


    I found a post :
    http://forums.pentaho.org/showthread...t=olap+refresh

    but when I insert

    <%
    if (mondrian.rolap.CachePool.instance() !=null )
    mondrian.rolap.CachePool.instance().flush();
    %>

    in my testpage.jsp (.\pentaho-demo\jboss\server\default\deploy\pentaho.war)
    It's not work.

    Thanks

  2. #2
    Join Date
    Jun 2007
    Posts
    2

    Default

    [QUOTE=Thibault;170663]Hello,
    I use pentaho_demo-1.2.1.625-GA

    I make two portlets using Pentaho Cube designer.
    All work greate (I can lunch the xaction).
    (file deploy with the designer)

    My portlet use a SQL database to consum data. But when I insert other data in ma database, my portlet is not update. (if I lunch again the portlet, the result is the same).

    I think that, Pentaho use cache. But what can I do to clear this cache ?
    I would like to have an automatic method.
    For example, when my xaction is lunch, I would like to auto refresh the page every 10 minutes, for update the olap cube.


    I found a post :
    http://forums.pentaho.org/showthread...t=olap+refresh

    but when I insert

    <%
    if (mondrian.rolap.CachePool.instance() !=null )
    mondrian.rolap.CachePool.instance().flush();
    %>

    in my testpage.jsp (.\pentaho-demo\jboss\server\default\deploy\pentaho.war)
    It's not work.

    Thanks

    sorry, i'm a little OT, but how you have created a portlet with an olap cube? i don't manage to develop an xaction, simply using PivotComponente, to see my cube in a portlet deployed in Jboss portlet.

    can you help me?

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.