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 ...
Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
