This white paper describes how application developers can apply performance-tuning techniques to their Microsoft SQL Server 2005 Analysis OLAP solutions. It's a very interesting and thorough (and long!) paper and well worth a read. Download it here Also...