I understand your point about the data cleansing. Why should it be necessary? One, it will help analysis services when you import the tables because it will see the relationships. Two, just in case something is wrong somewhere, the FKs might show it. I recently had a case where having FKs showed an issue that would not have shown up otherwise.