Microsoft has released a valuable white paper with a self-explaining title: SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.
The document has a part of explanation of terms and counters, and a large part of sample queries with a detailed tutorial teaching how to use SQL Profiler, with many comments about obtained results.
It’s a must read.