Login timeout expired error with Usage-Based Optimization Wizard

When I try to use the Usage-Based Optimization wizard to add aggregations, I'm getting a Login timeout expired error. Has anyone else seen this error? The cube is getting to be pretty substantial. It has 8 measure groups and I lost count of the number of dimension hierarchies.

Have you configured your query log table? Do the SQL server with your query log is accessable. Here is whitepaper on how to configure query log. http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/config_ssas_querylog.mspx

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.