Mosha released a new version of MDX Studio (0.4), which offers an “MDX Analysis” function that suggest best practices for a given MDX query.
I tried the tool with some MDX query and it offers very good suggestion (when possible with link to further information about the issue) for both the MDX beginner and the MDX veteran. Sometime, the suggestion cannot be applied because you really want to make a particular “slow” calculation, but in general the approach is pretty good. A further step would the a “pluggable” architecture to extend best practices rules, just as FxCop does. However, chances are that not so many peopla have the time to implement additional rules, so it could be a useless effort and Mosha’s time would be better spent on extending existing rules in the future.