I found this over at the SQL Server Manageability Team Blog.   It will help analyze your OLAP databases and give you recommendations for performance.   It is worth a look...

"The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment."

"This download is the February 2007 Community Technology Preview of SQL Server 2005 Best Practices Analyzer."

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

Regards

Patrick