O'Reilly logo

Expert Cube Development with SSAS Multidimensional Models by Marco Russo, Alberto Ferrari, Chris Webb

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

Modeling Slowly Changing Dimensions

Slowly Changing Dimensions (SCDs) are a fact of life in almost all data warehouses; we discussed how to deal with them in our relational model in Chapter 1, Designing the Data Warehouse for Analysis Services, and we'll now look at the issues that arise with each different type when building Analysis Services dimensions. In many cases, of course, different attributes on the same dimension can be subject to different types of change and we will use a combination of the techniques outlined in the next section, but it's helpful to discuss the three most common types of change separately for the sake of clarity.

Type I SCDs

Since changes in Type I SCDs involve overwriting existing values in the dimension table, no ...

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