Agree completely. If you're not sure where to put it, you need to read up on warehouse design. Since you're using SSAS, I recommend Ralph Kimball. It's important to get this right, because if you don't and the data is not useable, you will have wasted a lot of time.