Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: refresh of data

  1. #1

    Default refresh of data

    hello everybody,

    I have an analyser view published for the users of the BI platform. the data in the background is refreshed every night.

    when the user opens the analyzer view, then the data is not refreshed. the user will have to click on "clear cache", close the view and open it up again.

    is there any way to force a refresh of the data when opening the view?

    thanks,

    uwe

  2. #2
    gmoran Guest

    Default

    No, but you can clear the Mondrian cache (this clears the ENTIRE cache for all users) by configuring the following action sequence to run on a nightly schedule after the data is updated:

    <your_installation>/bi-server/pentaho-solutions/admin/clear_mondrian_schema_cache.xaction.

  3. #3

    Default

    I never understood the real impact of doing this. clearing the cache could have a severe impact on the performance of the cube, I guess. so the cache will have to be re-built and this is usually done by the users. they (at least the first ones) will suffer from bad performance, right?

    from a user perspective I think it would be good to have a refresh button, that reloads the data in the analyzer view iso using a cache.

    rgds,

    uwe

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.