I wish to hide individual dimension members.
I have a fact table that lists brand names and the amount sold in a month.

I use Analysis Services to produce reports of the dollars sold by brand over
months.

The data is collected by a research panel and so sometimes the brand
information is not filled in. The result is that there are serveral brands
that are captured as "OTHER", "NOT SPECIFIED", "NOT REPORTED" and a couple
others. I wish to filter out these brands on my report, but I still want to
have their dollar figures aggregated in my total.

The ideal is to have some logic that says,
"If the brand is "OTHER", "NOT SPECIFIED", "NOT REPORTED" don't show it but
still use its value in my aggregations"

If I simply filter out the data in my transactional database I will not get
the contribution of these brands in my totals.

What is the general mechanism that Analysis Services provides to achieve
this result?

Thank You, Jesse D.