Ok, thanks for the link! I ended up trying to process the cube seperately which allowed me to see what was causing the problem. But I'm still a bit curious...

Good question. I checked and it seems neither the fact nor the dimension have a composite key. Thanks for the suggestion though.

Thanks so much for your help! I checked out the Dimension Usage tab and it seems the relationship between the problem dimension and fact table got corrupted or was never...

Hi John,

When you added the dimension to your cube, did you establish the correct join between the dimension and fact tables? The fact and dimension may seperately be displaying the...

Hi Paul,

When you browse the cube in BIDS, do you see the new data?

Also, I realize the users aren't receiving any errors, but I was also wondering if any of...

Thanks for the information and tips. When I tried processing each of the dimensions seperately, I discovered that certain dimensions were failing consistently. This helped me to pinpoint some flaws...

I'm a newbie at SSAS and I've been having a similar issue with dimensions failing sporadically. When we process a cube, there are some errors that occur when some of...