Thursday, April 10, 2008
#
Apparently you have to watch out when you select Materialize in a referenced dimension in SSAS 2005. I just ran into a situation where data was getting duplicated for no good reason, and unchecking Materialize fixed it.
http://www.biblogs.com/2006/12/23/materialize-option-in-a-reference-dimension/