I have two named sets one called [Customers].[ThoseIWant] and the other
called [Gender].[GendersIWant].

Now I want to select in the where clause either customers I want or the
Genders I want as follows:


with member [Customers].[ThoseIWant] AS
'SUM(except({[Customers].[coun*try].[USA].children}, {[Customers].[All

Customers].[USA].[CA]}))'


member [Gender].[GendersIWant] AS
'SUM(except({[Gender].[Gender]*.members},{[Gender].[All Gender].[M]}))



Select {[measures].members} on columns ,
{[Product].[Product Category].members} on rows



Please let me know how I can perform a OR clause in the where clause.


Thanks
Karen

<karenmiddleol (AT) yahoo (DOT) com> wrote

I have two named sets one called [Customers].[ThoseIWant] and the other
called [Gender].[GendersIWant].

{[Product].[Product Category].members} on rows


It's easy:
Where ([Customers].[ThoseIWant] , [Gender].[GendersIWant])

Vini

If the syntax for a OR is what you specified. How would I do a AND like
the following

Select {[measures].members} on columns ,
{[Product].[Product Category].members} on rows

Thanks
Karen

Only replace the AND for a ,
Where espects a tuple.

Select {[measures].members} on columns ,
{[Product].[Product Category].members} on rows


"karenmiddleol (AT) yahoo (DOT) com" wrote: