Designing Real-Time Cubes - Professional SQL Server Analysis Services 2005 with MDX - page 953

would have been nice to have the update cache to happen at the same time each
day. Probably we will get this in future releases. However you can implement this
functionality using SQL Server Integration Services as seen in Chapter 16 . You
might have to reset the proactive caching property periodically to keep it aligned
with your business needs so that the most up to date data is available for your end
users. The configuration you setup using for updating cache periodically is also re-
ferred to as scheduled MOLAP since the cache update is scheduled. If you click
OK in the screen shown in 18-11 you will be in partition's properties pane where
you will see the scheduled MOLAP option selected as shown in Figure 18-12 .
Figure 18-11