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.

If the specific members to be excluded don't change, then a Named Set
can be used to exclude them as a group. Here's a sample MDX query for
Foodmart Sales cube, with such a set:

'{[Education Level].[All Education Level].[Partial College],
[Education Level].[All Education Level].[Partial High School]}'

Select {[Measures].[Unit Sales], [Measures].[Profit]} on columns,
Hierarchize({[Education Level].[All Education Level],
Except([Education Level].[Education Level].Members,
[ExcludedLevels])}) on rows
from Sales

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!