Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Update cube data on the fly

  1. #1
    Join Date
    Feb 2009
    Posts
    11

    Default Update cube data on the fly

    Hi

    I was wondering if it's possible to update a cube's data in mondrian in order to work with the updated data in jpivot without restarting mondrian app. We make daily data loads, and these data must be available as soon as possible; emptying mondrian's cache or restarting it causes us big trouble. Is it possible to reload a single cube's data from its database tables without restarting?

    Regards

  2. #2
    gmoran Guest

    Default

    Hi,

    The solution would require Java code. Mondrian does have a caching API that would allow you to flush a single cube's cache, which you could then reload either programmatically or via action sequences, PDI jobs, your tool of choice. You can find documentation on the caching API here ==> http://mondrian.pentaho.com/document...cheControl_API.

    The upside - you can control the cache at a very granular level. The down side - the Pentaho BI Server does not leverage this API at the granular levels yet.

    Hope this helps.

  3. #3
    Join Date
    Feb 2009
    Posts
    11

    Default

    Hi, Gretchen:

    We're studying the API in order to implement a simple Java/JSP interface which allows us to reload any cube data at any moment.

    We'll talk about our progress in this thread in order to give feedback to anyone who is interested.

    Thanks a lot for your answer!

Tags for this Thread

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.