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

Analysis Services Connection problem.

I am trying to test a connection in Reporting Services to an Analysis Services 2000 database. I get a Test Connection Succeeded from one machine and I can't even select the databases in the connection properties on another machine. What can I look at that might be preventing one machine from seeing the Analysis Services Server?

Thanks.

Security. If you hardcode the Windows credentials in the connection string does it work? This whitepaper may help.