Refreshing dashboard data
Data changes over time and, after every new load, cached datasets must be refreshed. Express accesses your RDBMS the first time you create a dashboard, and then stores a copy of the results for later analysis. Whenever the data changes on the data warehouse, Express must reload an updated copy. This can be done manually or on a schedule.
The manual process is the same as we used in the preceding recipe; just select database connection, tables, and fields; in this recipe, we will look at how the whole procedure can be automated to run unattended.
When automating schedules in Express, the time is always set according to GMT clock. This means that the daylight saving time is not taken into account, and your loads will run at a different time in summer (in case your country observes DST). For example, a 2 A.M. GMT load would run at 3 A.M. in Rome during winter, and 4 A.M. during summer.
Note
Bookmark this URL http://www.timeanddate.com/time/dst/events.html just in case...
