CPU Utiliization reaches 100% when using ExcelPivot Table to browse AS 2005 Cube

CPU Utiliization reaches 100% when using ExcelPivot Table to browse AS 2005 Cube. Only one user is using the cube. Its a single CPU with SQL Server running on the same box. Is there any configuration parameters I should be changing ?

Thanks

SelvaHi Selva,

This is nothing to do with your question. But I was wondering if you have been able to drill down hierarchy levels from your cube in your excel pivot table? Because I can't. Have you tried that. Also, I will say, that I had similar issue browsing a cube from the pivot table, but I had to filter my pivot table, so I wouldn't be pulling so many rows (3 million). Filter it down and see how it responds.