Issues with MSAS default members

We recently came across this confusing issue with how default members affect resultsets. If you use default members in your dimension, you may have this issue unknowingly and you should definitely check your reports which go out for validity.

Its been a long standing bug-bear of mine that there's no easy way in Excel of knowing that a default member has been set for an attribute, but this is entirely different and much more serious