Near Real Time OLAP using SSAS Proactive Caching
If I had a nickel for every time I've heard from a business user that the OLAP solution must support current real time data from the source system, I'd have at least half a dollar. The fact is that in reality there is usually some acceptable degree of latency. Even though Microsoft SQL Server Analysis Services has a ROLAP storage mode option, I've typically tried to steer people towards the MOLAP option due to it's query performance superiority.
Read more...