Scheduling data refresh
As we learned before, cubes are a big cache in the Intelligence Server memory. Their data is static. We need to update them when new data is available, typically after an ETL job is run.
Refreshing a cube's data involves connecting to the data warehouse and re-executing the underlying SQL statements. Normally, the best time to do it is during off-peak hours, and since BI developers like to sleep at night, there must be a way to automate that.
MicroStrategy offers a scheduling mechanism to automate cube updates very similar to cron on *nix or the Task Scheduler on Windows.
In order to automate a cube refresh, we need two objects: a schedule and a subscription.
A schedule is just a recurring timer, like every day at 3 A.M., ...
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.
