This is a simple example of SCD (Type-2) in OLAP cube.  We have a Dimension table for Employee and their Departments. This dimension is an SCD. One employee worked in different department over the course of time. EmpID is business key and SID is surrogate key. DimEmpolyee table We have another dimension called DimTime. … More Slowly Changing Dimension in SSAS Cube