I am building a cube and I have created a dimension called country. Our country table has many entries in it as it used by multiple systems for different things. In regards to my cube there are only a couple of countries that have data related to them. When I am looking at the data and I click the drop down to do a filter it is showing me every country. Is there someway that you can hide all these extra members so that the users do not have a list of 50 countries that don't mean anything to them. Basically I only want to show the members that actually have data against them in the cube.