against the FoodMart Sales cube I have the following query:

select
{[Measures].[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales



I want to now exclude sales Where Store Type <> "Head Quarters" and
StoreType <> "Supermarket"
and also I want to exclude the following in the sales reported
Education Level <> "Partial College" and Education Level <> "Partial
High School"

I do not have StoreType or Education Level in either the Rows or the
columns Axis I just want to exclude the above please note I am using
this as an example in another scenario I have sales for 200 customers
and I want to exclude the sales for only 4 customers and customers is
in neither of the axis.

Please help.

Thanks
Karen

OLAP client tool like Excel typically create aggregated members in the
Where slicer for select lists, like:

as
'Aggregate(Except([Education Level].[Education Level].Members,
{[Education Level].[All Education Level].[Partial College],
[Education Level].[All Education Level].[Partial High School]}))'
Member [Store Type].[All Store Type].[SelectedStoreTypes] as
'Aggregate(Except([Store Type].[Store Type].Members,
{[Store Type].[All Store Type].[HeadQuarters],
[Store Type].[All Store Type].[Supermarket]}))'

select
{[Measures].[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,
{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit
Sales],DESC) on rows
from Sales
where ([SelectedEdLevels], [SelectedStoreTypes])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak

Many thanks for your help

Thanks
Karen