Slowly Changing Dimensions

I'm building a data model at work that has slowly changing dimensions. The problem is that I've never worked with this type of dimension before.

So the problem is kicking my butt right now.

But despite the difficulty, novel problems like this make work fun—especially when you're working with data models.