Use relative date scheduling

Pentaho Business Analytics

Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17

When you schedule a report that contains startDate and endDate parameters, the Use Specific Date (default) and Use Relative Date options display on the third panel of the scheduling wizard.


New Schedule Use specific date dialog box

Choose the Use Specific Date option to specify the values of the start and end dates to use every time the report runs on the schedule.

Choose the Use Relative Date option to specify a time period relative to the day on which the report is run. The Start Date and End Date parameters are replaced by the Timeframe option parameters.


New Schedule Use relative date

The descriptions of the Timeframe parameters are:

Parameter Description
This The range from the start of the current Unit to today.
Units The time period to use .
Last The amount of the date range in the units specified by the Units parameter.
Value The size of the date range in the number of units specified in the Units parameter. This parameter displays when Last is selected.

When using these options, the values of the startDate and endDate parameters are the start and end of the current (This) or Last full specified period (Week, Month, Quarter, for example). Those values are calculated each time the report runs relative to that date, allowing you to write reports that contain data over progressively moving windows of time.