In the discussion below the example used is a report that will run once every 7 days against the default "Last 7 Days" Time Frame.
There are two parts to this we have to consider:
- The time the scheduled report runs on.
- The TZ the data within the report is framed against.
The Scheduler Edit UI will default the time the report runs to the users TZ configured. It can be changed in the Edit UI if desired. For example, running a report every week at 1 AM Sunday morning what TZ should the report launch at 1 AM Sunday morning? EST? GMT? ITC? Etc.
The TZ the report data is framed against, in this case using the default "Last 7 Days" option, is derived from the TZ configured on the user that set the schedule. When the reports scheduled run time arrives, each new run will perform a checks to determine the TZ set for the user that scheduled the report.
To resolve this:
- Create a new user.
- Suggested name would be something like ReportScheduler_<TZ> where <TZ> is the target for report data.
- Example: Using GMT it might be named:
- Set the TZ for the new user to the TZ the data in the report should be framed against.
- Assign the user a Role that has:
- Access to the necessary Menu options where the target Dashboard(s) reside.
- Access to the Groups the reports will run against.
- The "Send Reports on a Schedule" PC Role Right.
When a report needs to be scheduled against the GMT TZ:
- Log in to PC as your normal user.
- Go to Administration->User Settings->Users.
- Find the new ReportScheduler_<TZ> named user. Select the user and select the Proxy button.
- Schedule the report.
- Exit the Proxy user (select the X next to "Proxy User: <UserName>" in top right corner of web UI)