I've added effective dates to one of the fact tables in my data warehouse to allow reporting using different points in time. The application that generates the data for this only deals with history in a limited way, but I could see how an off the shelf solution to handle temporal stuff cleanly would easily be worth many developer-hours.