Using Advanced Storage
In this section, we will look further into SSAS storage. These storage settings help you to balance query performance with data latency. In earlier sections, you learned that using MOLAP will provide the best query performance. Now, we will look into the other two storage settings, HOLAP and ROLAP. For both storage types, source data is not copied to your cube. While HOLAP aggregations are stored in SSAS, ROLAP aggregations are built and stored in your database.
Understanding ROLAP
ROLAP is often used for rapidly changing dimensions (RCDs), and huge dimensions (also called monster dimensions). As an example, let's say that you are modeling a dimension that contains employee information for a fast-food restaurant chain. ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
