Thank you cees van diermen. I will check it out. That sounds exactly like what I need to do.

After doing a little research I am thinking thinking that I need to use a fact dimension. http://technet.microsoft.com/en-us/library/ms167409.aspx