Slowly Changing Dimensions handling in PowerPivot (and BISM?)

During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes in a SCD Type II dimension – you can probably generate them in a more dynamic way in PowerPivot (thanks to Vertipaq and DAX) instead of relying on a relational table containing all the data you need, which usually requires a more complex ETL process. This is particularly interesting for the next version of Analysis Services and it might impact the way we will design Data Marts for BISM Models in Analysis Services.