Alberto Ferrari wrote about an interesting issue he discovered working on optimization of dimension process using materialized reference dimensions.

I can understand SSAS behavior from a technical point of view, but it is not so obvious that an update of a dimension could result in returning wrong results from a cube. For this reason, I suggest you reading about the issue – maybe one day it will save several our hours of work.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2009/02/27/issues-materializing-reference-dimension.aspx