O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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