O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

Real-time solutions aren’t just for applications that need up-to-the-minute information; you can also use them to reduce latency to whatever level your business requires. Proactive caching is the foundation for real-time data availability from Analysis Services. Proactive caching works best when the new data is destined for a cube partition that contains only a small amount of recent data. Analysis Services can receive “push” notifications from SQL Server databases that new data has arrived. Other data sources can be polled to determine the availability of new data. You can tune the proactive cache settings to meet any latency requirements, and minimize unnecessary restarts of the partition reprocessing when data arrives in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required