Linus, To your second point, I did some more investigating, and I think I NUNIQUE will work for the time being. M2M is neccessary in certain situations where you need other measures to be view this way (other than counts), but I can roll with this for now. I'm starting to understand that SSAS is very unique in this regard, as well as with the multi fact setup. For what I need, I can just run proc sql statements to pull from different cubes and then join them together, although that is not as easy on the end user. Thanks for your help-- ... View more