Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PUC reports show old data even when data is updated?

  1. #1
    Join Date
    May 2014
    Posts
    4

    Default PUC reports show old data even when data is updated?

    Hi everyone

    I have installed biserver5.1 CE and can view published reports.

    However, when I update my data source (on the same server) I see the old (possibly cached) data?

    Here's what's happening:

    MongoDB is the primary database.
    A script populates a mySQL database from that MongoDB database (on the same server) in order to create tables etc to report off.
    (I'm not great with the Aggregation Framework etc in MongoDB )
    A cron job runs that populate script.
    When the reports are viewed in the PUC, I see old data.

    But when I republish the report (designed on my laptop using localhost as a FQDN and published to the biserver ), I see the latest data.

    What is wrong?
    I would have thought that the report would just soak up all the current data in whatever tables etc it finds.
    What do I need to do?

    Thanks very much
    Brad

  2. #2
    Join Date
    May 2014
    Posts
    4

    Default

    Hi everyone!

    Ok, I understand it now.

    I selected the report, and "scheduled" it to run once an hour.

    It shows the updated data.

    Hooray!

    Cheers
    Brad

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.