Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Need information on publishing the report and maintaining it

  1. #1
    Join Date
    Aug 2013
    Posts
    132

    Default Need information on publishing the report and maintaining it

    Hi all,

    I have successfully published the prpt report [in Html formt] in Bi server ce 4.5.
    I'm using ubuntu machine, 32-bit.
    The data source I'm using is Mysql database.

    As I have published the report in server, will the contents of the published report get changed whenever the data sources's table value changes.
    [example: pie chart, barchart values]
    or do ineed to schedule the report to get updated data from the data sources. will it be possible.
    if so how to achieve it.

    Please help.
    Thanks in advance.


    Malibu

  2. #2
    Join Date
    Mar 2012
    Posts
    276

    Default

    Hi ,

    help me if my understanding is wrong ,seems u published ur prpt report to server, so that u can access report from PUC , so that this give results from table (if ur tables is updated daily, updated records are reported ) . this how report works .

    if you placed ur static report (.html report) in puc, for easy access of user , than executing same report/Query 2wice for a day .then u need to replace ur static file regularly as per updated table . in this scenario reporting output step in PDI or xaction report (move report to a folder after execution ) will help

  3. #3
    Join Date
    Aug 2013
    Posts
    132

    Default

    Hi Surya,

    Thanks for your kind reply.

    yes, you got my point.
    But, Please make me to understand the flow clearly.

    I have already published the report into Bi server.
    Now I have scheduled that report to Run on Daily basis at 9:00 Am.
    My Database table will update on daily basis at 1:00Am in morning .

    Will the scheduled report will able to pick the data from the desired database tables on Regular basis.
    When I manually changed the Database table values , and again re opend the respective report in PUC I got to know that my report got changed.
    Hence I believe the it will be automatially change the report values on daily basis.

    If I'm wrong please help me in understanding the work flow.

    Thanks,
    malibu

  4. #4
    Join Date
    Mar 2012
    Posts
    276

    Default

    you are absolutely correct . scheduled will do that for you .!!!

    cheers

  5. #5
    Join Date
    Aug 2013
    Posts
    132

    Default

    Hi Surya,

    Thanks a lot for clearing my doubt.

    You ROCK!!!! Surya...

    Thanks,
    Malibu

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.