If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing your cube you may be a little confused. Here were some of my frustrations with it:
The only clue I had was one warning line after all the errors that referenced the column that was the culprit. The warning didn't even really directly tell me the problem but it did show me a column to look at. Turns out there were nulls in this column that caused the problem. I should have known! However, with the laundry list of errors that I was given it, that had nothing to do with the real problem attribute, it was hard to determine that nulls in a column was the real problem. Hope this helps!