Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Report sheduling with dynamical change parameters.

  1. #1
    Join Date
    Oct 2017
    Posts
    2

    Default Report sheduling with dynamical change parameters.

    Hi! I need to shedule my report to execute every day. I use Post-processing formula where date parameter = NOW(), but i recieve every day the same report.

  2. #2
    Join Date
    Oct 2017
    Posts
    2

    Default

    So, it was simple cache. For sheduling check your master-report parameters in PRD. I switched all caches off and reupload report to BI server. Now it works fine!
    Assume that we want to shaedule report with date range paramaters dateFrom,dateTo.
    For shedulling check 2 steps:
    in report designer (PRD)
    1) dateTo paramter EditParameter-> Post-Processing Formula = NOW();
    dateFrom parameter EditParameter->Post-Processing Formula= YESTERDAY();
    2) Structure -> MasterReport -> Attributes: dat-acahe=false, report-cache=false,dynamic-report-cache=false
    Have a nice sheduled report!

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 - 2017 Pentaho Corporation. All Rights Reserved.