Default Member Trap (be careful of what you filter)

Default members are a great way to customise user visibility without limiting cube access through some other security restriction. However, there is an interesting issue around the use of default members and analysis in excel. When a default value exists, and the level is used as a filter in excel, the data displayed is limited to the default member and not the filter in the pivot.