Dimensions That Change
After you've selected the type of dimension to be used for your particular business scenario, another important concept is whether and how your model will support update behavior for the dimensional attribute values. To understand how to model for updates, consider that updates in SSAS need to be divided into two types: new values (or inserts) and changes (or updates or deletes of existing attribute values). Allowing inserts of new values for the dimension or fact tables does not require you to use any special modeling techniques. However, the business rules required for changes to dimensional attributes will affect the way you model those attributes.
In Chapter 2, we introduced the topic of modeling slowly (or rapidly) ...
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.