I found a short but very useful MDX Performance
article on sqlserveranalysisservices.com. I know I am guilty of breaking not once the first rule (Don’t Filter on Member Property Values). Maintained by Richard Tkachuk (Lead Program Manager on the SSAS team), this site offers other interesting tips and insights.