Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MDX 2 Filters Connected By Or Keyword

Posted on 2009-04-02
1
Medium Priority
?
564 Views
Last Modified: 2012-05-06
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

0
Comment
Question by:Kaporch
1 Comment
 

Accepted Solution

by:
Kaporch earned 0 total points
ID: 24060004
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question