Hi,

We have several users who have created excel pivot table reports against an OLAP cube and on one of the dimension attributes they have a filter which was set to filter on 3 values.  However, after some recent changes to the OLAP cube, when they refreshed the pivot table, all of the filtered values on that one attribute disappeared and it was set back to ALL.  This was a pain for users to have to go back and set the filters for all their pivot reports.  So, I'd like to understand what changes to an OLAP cube might cause this behavior. 

Thanks,