MDX 2 Filters Connected By Or Keyword

I have the requirement that a schedule should be completed for any people with a one-time spend greater than $50, or an aggregate spend greater than $250.  Below I have the individual queries.  Is it possible to combine these conditions using an 'OR' into 1 query?  I don't want any overlap -- in other words, people selected from the 1st query should not also be selected from the 2nd query.

Code samples appreciated.
-- Query 1
select 
([Measures].[Spend Count].Children, [Beneficiary].[Address].Children, [Activity Start Date].[Date]) ON COLUMNS,
{Filter ([Year Quarter Desc].Members, [Measures].[Total Spend Amount] > 50)} ON ROWS
FROM Spends
WHERE [Party Role].[Beneficiary].[Beneficiary Role].&[Caterer]
 
--Query 2
WITH MEMBER Measures.Year AS SUM
	({[Year Quarter Desc].&[2008/Q1], [Year Quarter Desc].&[2008/Q2]},[Measures].[Total Spend Amount])
	select [Beneficiary].[Full Name] ON COLUMNS,
	{Filter ([Year Quarter Desc].&[2008/Q1], [Measures].[Year] > 250), 
	Filter([Year Quarter Desc].&[2008/Q2], [Measures].[Year] > 250)} ON ROWS
	from spends

Open in new window

KaporchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KaporchAuthor Commented:
Another question that I think I found my own answer to below.
WITH MEMBER Measures.TotalVendorSpending AS SUM
	({[Year Quarter Desc].&[2008/Q1], [Year Quarter Desc].&[2008/Q2]},[Measures].[Total Spend Amount]) 
	select [Beneficiary].[Full Name] ON COLUMNS,
	IIF([Measures].[TotalVendorSpending] > 250, [Measures].[TotalVendorSpending], {Filter ([Year Quarter Desc].Members, [Measures].[Total Spend Amount] > 50)}) ON ROWS
	from spends
	WHERE [Party Role].[Beneficiary].[Beneficiary Role].&[Caterer]

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.