Report Portal

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...

Tags: design, rolap

 

2007-2015 VidasSoft Systems Inc.