Analysis services freezes on Processing a Cube

I have not succeeded in processing my cubes because anaylsis services freezes when ever i run process cube. What could be the reason for this. Thanks in anticipation for your help

Hi!

You should check firstly which step of the processing work you are having problems.

I suggest to trace the SQL sentence executed by SSAS against the source database to see if there exists problems in resolving the query.

Then, if no problems are encountered I would check if it stops when processing a dimension or a measure group, or when calculating the aggregations.

Thanks

Leandro