Hey Mack,

Thanks for all the great suggestions. So turning off the parallel processing appears to have done the trick. I have been able to run the query 10 times without fail.

I was going to re-order the processing but it is working now so I won't touch it.

😉 Not sure what long term effect this will have but this should buy me more time to develop a much better understanding of what exactly SSAS is.

Thanks again,

Padraic