I just wanted to know is it possible or any solution that if i had 2
dimension lets said dimenson a and dimension b.Both dimension is not a
calculated member

In sql i can have a query statement like
select total from sales where name='a' or product='b'

but can the MDX use or for the where clause.

select {total} from sales
where dimension a or dimension b

Any possible solution that i can get the same result like the sql
query statement if MDX cannot use or in where clause

Thanks Brian
The solution can be use but then if the current member cannot find
then it will give error and if the set didnt match also it give error.

ANother thing that i need to as if im doing this way

WiTH

MEMBER product.ProductFilter AS 'Aggregate (
{Filter([product].members, [product].CurrentMember.Name="a" OR
[product].CurrentMember.Name="b" OR [product].CurrentMember.Name="c"
OR [product].CurrentMember.Name="d") } )'

MEMBER store.StoreFilter AS 'Aggregate(
{Filter([store].Members,[store].CurrentMember.Name="storea" OR
[store].CurrentMember.Name="storeb")})'


Can i use the above member as OR in rows like the below statement you
mention???

select
{[Measures].[Unit Sales]} on columns,
filter ( [product].members * [store].members ,
product.currentmember is [drink] or store.currentmember is [CA] ) on
rows
from Sales



alextsh79 (AT) maxis (DOT) net.my (Alex) wrote in message news:<2fa6aa50.0407140341.3d9811c1 (AT) posting (DOT) google.com>...